Weird Reference: Tab-Name!CB_dbd73ad601d445... instead of Tab_Name!A1

[TomC4]

I have a spreadsheet that's acting funny.

When I try to link from one tab to another, most of the time it works as usual.

But sometimes rather than creating links to other tabs in the normal form Tab_Name!A1 mine will appear in the form Tab-Name!CB_dbd73ad601d445... (I shortened it - the alphanumeric string on the end of the tab name is about 30 characters long).

Screenshot


They seem to work fine. But I haven't tested thoroughly. And I can manually change them back to the normal format if I notice them.

But this is an important spreadsheet so I don't want to mess around and would love to get things back to normal.

Any ideas how to do so? Thanks in advance!

 

[cyrilbrd]

Hi, just a thought, is one of your file located on a different server or on the cloud?

 

[TomC4]

Hi, just a thought, is one of your file located on a different server or on the cloud?

It's saved locally on my computer.

It did originate as a Google Sheets file. The file got too big / complex for Sheets to handle well - it started to take like a min to switch tabs - so I downloaded it as an .xlsx.

But I have been using it for a week since downloading from Sheets with no problems until today so I'm not certain that's causing the issue.