Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a workbook with quite a few sheets, many having formulas that refer to
other sheets. Sometimes when I make changes to some of the cells in certain sheets, I'll get #REF!'s on other sheets/cells. I'm thinking I'd like to have a separate sheet that would show which sheets have #REF!'s., something like: Sheet a! ok Sheet b! Ref Sheet c! Ref Sheet d! ok So I could easily goto that sheet and fix the #REF!. Is that possible ? Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
creating tabs with sub tabs | Excel Worksheet Functions | |||
sheet tabs is checked but I can't see my tabs | Excel Discussion (Misc queries) | |||
tabs are missing even though 'tools-options-view-sheet tabs' ok? | Excel Worksheet Functions | |||
hide tabs from view then lock tabs? | Excel Discussion (Misc queries) | |||
Can i set up tabs within tabs on Excel? | Excel Worksheet Functions |