+ Reply to Thread
Results 1 to 4 of 4

Formula Refers to Sheet not in Workbook!...HELP!

  1. #1
    Registered User
    Join Date
    07-26-2012
    Location
    Tetbury, England
    MS-Off Ver
    Microsoft 365 MSO
    Posts
    73

    Exclamation Formula Refers to Sheet not in Workbook!...HELP!

    Hi All,

    Have been sent a spreadsheet; one which comes from another source other than the person who sent me it i.e. a Third Party.

    It has a formula in the spreadsheet which (if i'm right) should be referring to a sheet within my workbook? HOWEVER, There is no sheet (as far as I can see) by that name...!

    I have checked:
    • Right Clicked on Sheets, to Unhide Hidden Sheets; Option is Greyed out (I assume none hidden then)
    • No Macros in Spreadsheet which are hiding or blocking me from getting to anything
    • Workbook and/or sheets are not protected
    • No Named Ranges in Name Manager

    So I am completley stumped! The formula I see is as follows:

    Please Login or Register  to view this content.
    Anyone here able to help me? I have attached the spreadsheet for you too...I am initially talking about the 8 Fold Tab and the formula I have pasted above is taken from cell D16 on that sheet!

    Thanks in advance for your help!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Formula Refers to Sheet not in Workbook!...HELP!

    Hello,
    All available sheets you can see it in vb editor. There are many sheets hidden, select the sheet you want to un-hide & change the visible properties.
    Please change the Visible properties to "-1 - xlsheetvisible". Kindly refer the screenshot for the same.

    excel prop.PNG
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  3. #3
    Registered User
    Join Date
    07-26-2012
    Location
    Tetbury, England
    MS-Off Ver
    Microsoft 365 MSO
    Posts
    73

    Re: Formula Refers to Sheet not in Workbook!...HELP!

    Hi There!

    Aha...i never thought to look there...stupid boy!

    Thanks for your help! Appreciated!

  4. #4
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Formula Refers to Sheet not in Workbook!...HELP!

    Happy to help, pls add reputation - - -- If my help assists you...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA - See if a cell has a formula that refers to another sheet
    By XSQUAD in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-06-2017, 11:01 AM
  2. [SOLVED] Formula that refers to a cell on a sheet that may or may not exist.
    By k1989l in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-01-2015, 02:50 PM
  3. Vlookup Different workbook Cell refers to sheet
    By RandomPezzer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2015, 05:42 PM
  4. Button refers to macro in the wrong workbook
    By Varia in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-24-2013, 06:14 AM
  5. Forumla which refers to a cell which refers to a sheet name
    By awiller2 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-03-2012, 09:57 PM
  6. Name assigned in workbook refers to range problem!!!
    By brucemc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-25-2006, 05:12 PM
  7. Replies: 2
    Last Post: 11-23-2005, 08:18 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