[Dropped] Maintain links between Calc files when moving them

[Daikymo]

Hello,

Like many people I now have to do my VAT via spreadsheets that link to one other. Obviously, that's not an issue with sheets within a single file, but I have account files that cover one financial year with the VAT overlapping two financial years (Feb/Mar/Apr).

I copy and link from one spreadsheet file to another and it works fine. However, the back ups, stored elsewhere, don't maintain links between themselves. Given that the links must remain valid for legal purposes I want to find the easiest way to ensure my back ups show all the relevant information, including these between file links.

Could someone advise, please?

Many thanks,

Rich

[Villeroy]

I don't see any reason why one should use linked sheets. Simply put everything in one file.

[Daikymo]

That is not my question. Each financial year goes in a separate file with everything to do with that year. This system is fine if I can keep links updated and I don't wish to change it.

[Hagar Delest]

Not an expert with Calc but have you made sure that the relative structure on the folders are the same between the original location and the backup location?
Usually links are relative and AOO goes up to the first common root folder and then goes down to the target folder.
First make sure that the structure of the backup folders is identical to the original one.

[Villeroy]

We don't even know what "link" means. I know 5 different methods to link one spreadsheet with another, not counting hyperlinks.

[Daikymo]

Not an expert with Calc but have you made sure that the relative structure on the folders are the same between the original location and the backup location?
Usually links are relative and AOO goes up to the first common root folder and then goes down to the target folder.
First make sure that the structure of the backup folders is identical to the original one.

Thank you. I'll have a look and see what they link to. Cheers

[Daikymo]

We don't even know what "link" means. I know 5 different methods to link one spreadsheet with another, not counting hyperlinks.

I've linked a piece of data in one spreadsheet to a cell in another. Then I back the spreadsheets up and the link is no longer working between them ie I get ### in the cell.

I just want to link the two and preserve the link to the back ups. I really don't care what type of linking happens and if you know 5 ways then I'm happy with the very easiest one that fixes the issue!

Cheers.

[Villeroy]

I've linked a piece of data in one spreadsheet to a cell in another.

Are you kidding? You still refuse to tell us HOW you linked your cells.

There are 4 easy ways and a powerful special one. We can not know which is the right one for you.