+ Reply to Thread
Results 1 to 2 of 2

Excel Spreadsheet Options not Remembered

  1. #1
    Registered User
    Join Date
    07-06-2012
    Location
    devon england
    MS-Off Ver
    office 2010
    Posts
    1

    Excel Spreadsheet Options not Remembered

    I have the problem that when I select the options from the file menu then the fomulas menu, where I set the workbook calculation to automatic from manual it is not remembered so when I open the spreadsheet again after saving and closing the calculation option is back on manual. This is happening for three out of ten worksheets!?

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Excel Spreadsheet Options not Remembered

    the calculation setting depends on the setting of the first workbook opened no matter what subsequent workbooks were saved with (unless they use code to change the setting)
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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