Results 1 to 4 of 4

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

Threaded View

WaylettChris Formula Refers to Sheet not... 12-27-2017, 08:57 PM
than_gold Re: Formula Refers to Sheet... 12-27-2017, 09:27 PM
WaylettChris Re: Formula Refers to Sheet... 12-27-2017, 09:45 PM
than_gold Re: Formula Refers to Sheet... 12-27-2017, 09:47 PM
  1. #1
    Forum Contributor
    Join Date
    07-26-2012
    Location
    Tetbury, England
    MS-Off Ver
    Microsoft 365 MSO
    Posts
    105

    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:

    =IF(calc_8!$B$534=calc_8!$B$535,calc_8!D3,"")
    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

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