I have a somewhat complicated formula in that it refers to a separate
spreadsheet. The formula works fine, but the problem seems to be that until
I open the referred to spreadsheet, I get a #value! error. I know that I
have used this type of formula before and didn't need to open the spreadsheet
to get my answers. Why is it doing it now?

It might help to let you know that the spreadsheet referred to was created
by access as a query, but I don't see how that changes it as I save the query
as an excel spreadsheet.

Any help would be greatly appreciated, as the spreadsheet generated refers
to 7 different files (Sunday - Monday) and I need to creat a new spreadsheet
for 8 different locations, so I would have to open over 56 files to get these
spreadsheets to the stores.