ImpetuousRacer
New Member
- Joined
- May 12, 2010
- Messages
- 9
Ok, I'm working with Excel 2007. I have a summary sheet that is .xls and it links to about 60 other xls workbooks. All workbooks are based off the same template. The cell I'm referencing is on a hidden sheet in the structure protected workbook. It was working for all workbooks, then all of a sudden, one workbook started returning an NA error.
The only way it works is if I open up the workbook, or if I unprotect the structure of the workbook, and save. Why would if work fine on all of them, then not this one out of the blue?
Additionally, I have another data table that uses vlookup function and I receive NA error unless the workbook structure is unprotected or if it is open. It worked fine when all templates were xlsm & was using an xlsx.
Is there a setting I need to change somewhere. This is highly frustrating. Thanks for the help!
The only way it works is if I open up the workbook, or if I unprotect the structure of the workbook, and save. Why would if work fine on all of them, then not this one out of the blue?
Additionally, I have another data table that uses vlookup function and I receive NA error unless the workbook structure is unprotected or if it is open. It worked fine when all templates were xlsm & was using an xlsx.
Is there a setting I need to change somewhere. This is highly frustrating. Thanks for the help!
Last edited: