+ Reply to Thread
Results 1 to 5 of 5

Error Message when saving or opening excel sheet

  1. #1
    Registered User
    Join Date
    06-15-2019
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    25

    Lightbulb Error Message when saving or opening excel sheet

    Hey Everyone,


    This is probably really simple, but i keep getting this annoying error message whenever I open this excel sheet or save it.

    This sheet is going to be my bare template sheet, so i would rather solve the issue now before I add any data to it. Can someone please take a look?

    The error:
    "Excel found a problem with one or more formula references in this worksheet
    Check that the cell references, range names, defined names, and links to other workbooks in your formula are correct"



    FYI, I am happy with the formulas in this sheet. I want a way to solve this without completely turning off error checking. The reason is because when I add data to the sheet, i want it to inform me if I have made any errors.

    Also FYI, I am aware that in the Money Management Sheet some cells in the first row (Row 19) may differ from the rest of the cells below. I am mentioning this just in case you think this is the error.

    The excel sheet is attached.

    Thanks in advance for all your help! I hope this is all clear
    Attached Files Attached Files
    Last edited by Mikes_KM; 06-01-2020 at 05:22 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: Error Message when saving or opening excel sheet

    Do any of your formulas reference another file (such as vlookup to another file on your computer)?

  3. #3
    Registered User
    Join Date
    06-15-2019
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    25

    Re: Error Message when saving or opening excel sheet

    Thanks for taking a look. No there should be no vlookup here referencing another doc
    Last edited by Mikes_KM; 05-30-2020 at 07:26 PM.

  4. #4
    Registered User
    Join Date
    06-15-2019
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    25

    Re: Error Message when saving or opening excel sheet

    As per my previous message, I tried different versions of this sheet. One old version included a vloookup but I got rid of it.
    This version shouldnt have a vlookup
    Last edited by Mikes_KM; 05-30-2020 at 07:27 PM.

  5. #5
    Registered User
    Join Date
    06-15-2019
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    25

    Re: Error Message when saving or opening excel sheet

    Hey does anyone know what the issue could be?

+ 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] Error message when first opening Excel
    By zookeepertx in forum Excel General
    Replies: 5
    Last Post: 10-24-2018, 11:57 AM
  2. [SOLVED] Error message when opening 2013 Excel in a Mac
    By mtndewgradon in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 11-06-2013, 02:37 PM
  3. Excel 2007 : Excel saving error message
    By gilbert in forum Excel General
    Replies: 6
    Last Post: 01-31-2010, 10:41 PM
  4. [SOLVED] error message when saving excel workbook
    By Deb in forum Excel General
    Replies: 1
    Last Post: 10-05-2005, 04:05 PM
  5. [SOLVED] Error Message When Opening Excel
    By Walid in forum Excel General
    Replies: 2
    Last Post: 07-27-2005, 05:05 PM
  6. Error message opening Excel
    By Ed in forum Excel General
    Replies: 1
    Last Post: 03-18-2005, 12:06 AM
  7. Error message on saving when in Excel
    By dpksy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-03-2005, 08:06 AM

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