linking to external files

[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

 

[Rita Palazzi]

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