I am working on a LARGE spreadsheet that has many links to other excel workbooks. All I get are #Value errors in every cell the refers to another spreadsheet, unless that spreadsheet is Open. I have manually went to each data link and Updated values, but still get the error.
When I send the spreadsheet to partners, they see all the errors, instead of the calculated numbers. Unless I break the links and re-save as another version. This is the 1st time I have experianced this issue. I copied this spreadsheet form an older version (I have been using the same set for a few years now, updating with new years data) 1st time in Excel 2010. Did I do something wrong when converting the file to 2010? I can't figure it out and need to fix this issue.
Bookmarks