Results 1 to 6 of 6

Find formulas (or errors) in hidden tabs

Threaded View

  1. #1
    Registered User
    Join Date
    02-21-2017
    Location
    London
    MS-Off Ver
    MS 365 (apps for business)
    Posts
    32

    Find formulas (or errors) in hidden tabs

    I have a shared workbook of weekly reports which has over 30 hidden tabs. Tabs are hidden so that only the current week's data is visible and the following week, that tab would get hidden and next week's tab would be visible and so on.

    Recently I've come across a message that there is a formula error somewhere in the workbook (see screenshot).

    How can i find which page has a formula / error in a workbook that has hidden tabs please, without having to 'unhide' every single tab?

    thank you
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hyperlinking to hidden tabs - hidden tabs unhide / hide automatically.
    By jexcelio in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-31-2016, 02:42 AM
  2. [SOLVED] Format all cells in all sheets to Protection Hidden on visible and hidden tabs
    By DeRo22 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-28-2014, 03:17 PM
  3. [SOLVED] trying to access the excel sheets/Tabs in the hidden/very hidden mode through hyperlinks
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-30-2013, 06:50 AM
  4. Find all tabs with formula errors
    By antiquest in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-28-2012, 12:09 PM
  5. Replies: 0
    Last Post: 08-01-2012, 11:03 AM
  6. How can I find/unhide hidden excel sheet tabs on a worksheet?
    By magician in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2012, 05:37 PM
  7. VBA to recurse sheets and find errors in formulas and cond formatting?
    By leaning in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-24-2010, 12:12 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1