linking to external files

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

Hello,

I am building a spreadsheet that links to external
spreadsheets for a lot of its data. External
spreadsheets exist for each month of the year. The
spreadsheet I am building has a Jan. tab linking to the
Jan external file, a Feb. tab linking to the Feb.
external file, and so on.

I would like to set up the spreadsheet with all the links
for the entire year but the external monthly files for
May onwards do not exist yet. As a result, when I open
my spreadsheet, it prompts me with an error message that
says the file does not exist.......for every future month
where a file does not exist yet.

Does anyone know a way to code the spreadsheet in advance
for each month, but not have the error message appear
every time the file is opened.

Thanks for your help.

Jason
 
You could create a "template" file to be a placeholder for the upcoming
months and reference it on your monthly tabs. Then, when you have the new
month available, change the references on that month's sheet only.

Just a thought.

Rita Palazzi
Senior Engineer / FedEx Express
 
Back
Top