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.
Hat Tip: Excel Hints: Find (and Delete) External Links
Philip Elder
MPECS Inc.
Microsoft Small Business Specialists
Co-Author: SBS 2008 Blueprint Book
*Our original iMac was stolen (previous blog post). We now have a new MacBook Pro courtesy of Vlad Mazek, owner of OWN.
Hi,
ReplyDeleteIt's very very useful for me to solve excel 2007 issue. Thanks!
SHREE
Worked perfectly. Thanks!
ReplyDeleteThat first step shouldn't be necessary. When you hit 'search in workbook' it searches all sheets automatically (unless they're hidden).
ReplyDeleteThanks. Saved me a boatload of time!
ReplyDeleteThis steered me in the right direction. I had a small spreadsheet, so I did the "show formulas" command (CNTRL+`) and found a formula referencing another spreadsheet. I replaced the formula with text. I saved the file, closed it, re-opened it, and the "Security Warning" disappeared. THANK YOU.
ReplyDeleteGlen
Canyon Country, CA