Sending linked spreadsheets via email

[tfoale]

I have two workbooks in the same folder which are linked bidirectionally. I send the files to a colleague, he updates them, increments the version number and then sends them back to me. I store them both in the same folder before opening them. However, on opening all links in one workbook have the form:

Please Login or Register  to view this content.

.
The filename is correct (the updated book) but the sheet name, which hasn't changed, is now a #REF. Redefining the links restores the functionality but is going to become difficult when the plan is shared more widely.

Does anyone have any idea why this is happening and what I can do to make the links work permanently?

[NapB9]

Hi,

You mention that your colleague "increments the version number" on the file. I realize you said the filename is correct, but the file has to be saved identically as it was previously. So you would need to save it as "XXX Business Plan" every time instead of "XXX Business Plan 1"... "XXX Business Plan 2", etc.

Hope this helps.