Skip to Content (Press Enter)
UserImage.jpg
Russell Moore
14Views
3Comments
Solved
[Advanced Excel] "The address (GT14) collides with an existing validation (GT14)"
Question
Forge
Service
advanced-excel
Service icon
Advanced Excel (O11)
Forge asset by Carlos Freitas
Application Type
Service

Good evening.

I am downloading an Excel (xlsm) workbook (quite a large, complicated one) from a record in an entity, but when the Workbook_GetBinaryData is being run the error in the title is being displayed.

Looking at every worksheet, there doesn't appear to be any validations or conditional formatting on cell GT14.

Is there any way to get more information about this error or any clues as to how to investigate or resolve it?

I have removed any code amending the workbook to ensure I am not introducing an issue, and the workbook works fine before it is uploaded into the record in the entity.

Thank you in advance.

Russ.


0
0
15 Jan 2025
Copy Link
UserImage.jpg
Russell Moore
Solution

Replying to You's comment on 16 Jan 2025 08:45:35

Update on issue:

I have managed to narrow the problem down to a single cell (unsurprisingly GT14) on a specific worksheet, by systematically removing worksheets and attempting the download again and again...

The cell did have validation on it (an input message only) but removing it did not resolve the issue.

However, copying a completely blank cell over the top did resolve the issue and re-applying the validation enabled the process to complete.

I am assuming there was something getting confused in the background in Excel, causing the issue, but it is now fully resolved from my perspective.

Thank you again for the very prompt response, @Anh Duong.

One request/suggestion for a future development if any developers are reading this, would be to also include the worksheet name in the error message if possible.  This would save considerable time when trying to diagnose a large workbook.

Thanks,

Russ.

See solution in context
0
0
16 Jan 2025
Copy Link
2025-04-21 14-34-14
Duong Hoang Anh

Hi @Russell Moore, I think this Excel file, which was previously created by you, has merged cell GT14 with another cell. Please open the Excel file and check it. 
Thanks,
AnhDH

0
0
16 Jan 2025
Copy Link
UserImage.jpg
Russell Moore

Hi @Anh Duong .  Thank you for such a quick response - it's much appreciated.

I have looked through every worksheet in the workbook and none of the sheets have cell GT14 merged with any other cells.

I have now also ensured that all rows and columns are unhidden and every worksheet is visible.  I didn't think this would make any difference, but at least this is now ruled out as an issue.

Are there any other conditions you are aware of that I should check?

Cheers,

Russ.

0
0
16 Jan 2025
Copy Link
UserImage.jpg
Russell Moore
Solution

Replying to You's comment on 16 Jan 2025 08:45:35

Update on issue:

I have managed to narrow the problem down to a single cell (unsurprisingly GT14) on a specific worksheet, by systematically removing worksheets and attempting the download again and again...

The cell did have validation on it (an input message only) but removing it did not resolve the issue.

However, copying a completely blank cell over the top did resolve the issue and re-applying the validation enabled the process to complete.

I am assuming there was something getting confused in the background in Excel, causing the issue, but it is now fully resolved from my perspective.

Thank you again for the very prompt response, @Anh Duong.

One request/suggestion for a future development if any developers are reading this, would be to also include the worksheet name in the error message if possible.  This would save considerable time when trying to diagnose a large workbook.

Thanks,

Russ.

0
0
16 Jan 2025
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.