Okay, so not quite a fix. But, we have a number of different Excel spreadsheets that we use to build our system, solution, and proposal quotes structures with the lot of them tying in to each other.
Somewhere along the line while editing one of them the following error started to appear an a leaf workbook (Trunk = full proposal, Branch = hardware, software, or labour, Leaf = Individual components/servers/etc.):
Security Warning: Automatic update of links has been disabled. Enable Content
Okay, so how do we find these links?
A quick search turned up the following methodology:
- Highlight all sheets by CTRL+Clicking on them.
- CTRL+F to bring up Find
- Click the Options button.
- Change Within to: Workbook
- Look in: Formulas
- Find What: [
- Click the Find All button.
Ah, now it becomes clear as to what happened to bring about the error. An errant copy and paste.
Now that we know where the problem is, we can fix it and no longer receive the warning for this particular leaf workbook.
Microsoft Small Business Specialists
Co-Author: SBS 2008 Blueprint Book