All articles with 'spreadsheet maintenance' Tag

Show all the names & their References [Spreadsheet Audit]

Published on Sep 20, 2010 in Excel Howtos
Show all the names & their References [Spreadsheet Audit]

We all have been there. You started to build a simple workbook to keep track of an ongoing project or dashboard or something equally complicated. Even before you realize the workbook has 23 sheets and 41 named ranges all going from one place to another, like flying spaghetti monster, only less awesome. Now, how do […]

Continue »