Spreadsheet Guys - Calendar Template

FAQ

 
Problem:  Formula navigator is unable to trace or navigate to cells on hidden worksheets.
   

Solution: 

Ensure that relevant worksheets are un-hidden before using formula navigator. Formula Navigator displays a warning message when it is launched if there are any hidden worksheets in open workbooks. 
   
   
Problem: Formula navigator is unable to trace or navigate to cells on protected worksheets.
   

Solution:

Ensure that relevant worksheets are un-hidden before using formula navigator. Formula Navigator displays a warning message when it is launched if there are any protected worksheets in open workbooks. 
   
   
Problem: Formula Navigator is unable to trace or navigate cells from a protected worksheet.
   

Solution:

Unprotect the relevant worksheet (depending on your security settings, this may require a password) before attempting to trace or navigate from this worksheet. 
   
   
Problem: Formula Navigator is unable to trace or navigate to an external link if the external workbook is closed.
   
Solution: Open the external workbook in the same instance of Excel before attempting to navigate again. (Note: This also applies to and defined named ranges in Excel that refer to an external workbook). 
   
   
Problem: After making structural changes to the model, formula navigator is no longer linking to the correct cells.
   
Solution: Formula Navigator records the addresses of cells and ranges of precedents/dependents at the time a formula or cell is traced. Any structural changes to the spreadsheet after this are not revised in the listing. If this becomes too confusing, use the ‘Clear History’ functionality and re-trace any cells as required.
   
   
   

 

 

 

 

 

 

 

 

 

 

 


 

 

Limitations

Unfortunately as Formula Navigator relies on the in-built logic within Microsoft Excel to trace formulas, it therefore is bound by the limitations of Microsoft Excel when it comes to auditing formulas. Please refer to the FAQ section on this website for more information as well as solutions to these limitations.

bug.reporting@spreadsheetguys.com


About Us  |  Contact Us  | Policies  |  Glossary  |  Testimonials  |  Webmaster
Copyright ©  2007-2017 SpreadsheetGuys.com. All rights reserved. Microsoft Excel® is a registered trademark of Microsoft Corporation.
Site last updated 24th January 2017
 
.
.

 

Friends of Spreadsheet Guys Include: AceTheCase.com ~ Consulting Case Interviews Questions & Job Interview Questions
Our most popular downloads include our Free Excel Calendar Template & Free Excel Invoice Template
and the unrestricted Excel Calendar Template for just $9.95 and the unrestricted Excel Invoice Template also $9.95