Why would it be missing in a file saved under a different name?
Best guess: You are saving your copy to a different directory. Then your external file reference that works for the original file will be unable to find it. If you check your external file reference under Manage | External Data Sources... and can't figure it out. Copy the text, paste it here and we'll take a swing at helping you understand it.
Thanks for your help. I did sort that out by re-assigning to file locations. What is strange is that I've been using the file for over 2 years now since ver 7.0 and not had this problem. I am constantly saving the file in different directories, sorted by year/customer/project - old pc habits die hard :)
Is there a way of having any new file find the related tables without manually changing the external data sources every time. I notice on the original file that in external sources I cannot save the location of the table files with complete file extension - i.e. home>company>databases>filename, it simply saves the original as >filename . In the "saved as" file the full extension is shown. If I were to relocate the full related table file to another directory, would that help?
It's hard to tell without actually examining your file's data source references.
The behavior I am describing has not changed since way back. I suspect that your external data source reference has changed in some way.
You can set up an absolute data source reference under Manage | External Data Sources:
will work for you. If you're a mac user, you'll need a slightly different format.
You can see examples of both mac and windows formats, when you Choose Manage | External Data Sources... and double click a reference to edit it.
The absolute reference should work perfectly for me. Thanks for the help !