Page 1 of 2 12 LastLast
Results 1 to 16 of 21

Thread: Excel asking to save but...

  1. #1
    Senior Member Giraffe's Avatar
    Join Date
    Feb 2007
    Location
    near Northampton
    Posts
    841
    Thanks
    34
    Thanked
    39 times in 34 posts
    • Giraffe's system
      • Motherboard:
      • Gigabyte GA-Z97-D3H
      • CPU:
      • Intel Core i5 5675C, S 1150, Broadwell, Quad Core, 3.1GHz, 3.6GHz Turbo
      • Memory:
      • Crucial Ballistix DDR3 1600, 4GB
      • Storage:
      • 512GB Samsung SSD, 850 Pro, SATA 3
      • Graphics card(s):
      • Integrated
      • PSU:
      • Seasonic S12G 450W 80+ Gold
      • Case:
      • Antec P100
      • Operating System:
      • Windows 7 Pro, 32-bit
      • Monitor(s):
      • Dell U2415, 24", 16:10
      • Internet:
      • TP-Link modem-router; 3mbps sync.

    Excel asking to save but...

    If I open an Excel file just to look at it and then close it, Excel asks if I want to save the changes that I've made - but I haven't made any.

    I've looked through the Options and can't see anything obvious to untick. Anybody know how I can stop this, please?
    PeterC

    Political lubricant:

    Rocket WMD45

  2. #2
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,164
    Thanks
    803
    Thanked
    2,152 times in 1,408 posts

    Re: Excel asking to save but...

    open it as readonly.

    It sounds like you have a volatile function or something similar which is causing the sheets state to change, which is therefore making it prompt you.

    a classic example would be "=today()"
    throw new ArgumentException (String, String, Exception)

  3. #3
    Senior Member Giraffe's Avatar
    Join Date
    Feb 2007
    Location
    near Northampton
    Posts
    841
    Thanks
    34
    Thanked
    39 times in 34 posts
    • Giraffe's system
      • Motherboard:
      • Gigabyte GA-Z97-D3H
      • CPU:
      • Intel Core i5 5675C, S 1150, Broadwell, Quad Core, 3.1GHz, 3.6GHz Turbo
      • Memory:
      • Crucial Ballistix DDR3 1600, 4GB
      • Storage:
      • 512GB Samsung SSD, 850 Pro, SATA 3
      • Graphics card(s):
      • Integrated
      • PSU:
      • Seasonic S12G 450W 80+ Gold
      • Case:
      • Antec P100
      • Operating System:
      • Windows 7 Pro, 32-bit
      • Monitor(s):
      • Dell U2415, 24", 16:10
      • Internet:
      • TP-Link modem-router; 3mbps sync.

    Re: Excel asking to save but...

    Thanks for the suggestion.

    I do have =AQ20/((DATE(2010,12,31)-TODAY())/30.4166)

    and =YEAR(NOW())-1970

    and =YEAR(NOW())-1947

    but I have the same spreadsheet as *.ODS in OO Calc and that doesn't ask for save.

    I can't make it Read Only as it is altered daily and opened just for ref. 1 or more times a day.
    PeterC

    Political lubricant:

    Rocket WMD45

  4. #4
    SiM
    SiM is offline
    Senior Member
    Join Date
    Apr 2006
    Location
    London
    Posts
    7,787
    Thanks
    300
    Thanked
    633 times in 422 posts
    • SiM's system
      • Motherboard:
      • P5K Premium
      • CPU:
      • Q6600
      • Memory:
      • 8GB PC2-6400 OCZ ReaperX + Platinum
      • Storage:
      • 3 x 320gb HD322HJ single platter in Raid 0
      • Graphics card(s):
      • PNY GTX285
      • PSU:
      • Corsair TX650W
      • Case:
      • Antec 1200
      • Monitor(s):
      • 2407-HC

    Re: Excel asking to save but...

    Turn automatic calculation off. If you are a serious spreadsheet user then you shouldn't be using automatic calculation - it's for n00bs.

    I will introduce you to your new best friend: Shift+F9

  5. Received thanks from:

    Giraffe (11-09-2009)

  6. #5
    Senior Member watercooled's Avatar
    Join Date
    Jan 2009
    Posts
    11,459
    Thanks
    1,539
    Thanked
    1,022 times in 868 posts

    Re: Excel asking to save but...

    I think it also asks you to save if you highlight a different cell.

  7. #6
    SiM
    SiM is offline
    Senior Member
    Join Date
    Apr 2006
    Location
    London
    Posts
    7,787
    Thanks
    300
    Thanked
    633 times in 422 posts
    • SiM's system
      • Motherboard:
      • P5K Premium
      • CPU:
      • Q6600
      • Memory:
      • 8GB PC2-6400 OCZ ReaperX + Platinum
      • Storage:
      • 3 x 320gb HD322HJ single platter in Raid 0
      • Graphics card(s):
      • PNY GTX285
      • PSU:
      • Corsair TX650W
      • Case:
      • Antec 1200
      • Monitor(s):
      • 2407-HC

    Re: Excel asking to save but...

    No selecting another cell doesn't. Another solution is to disable the save prompt for that book. There is an option in vba to do this iirc.

  8. #7
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,164
    Thanks
    803
    Thanked
    2,152 times in 1,408 posts

    Re: Excel asking to save but...

    Quote Originally Posted by Giraffe View Post
    Thanks for the suggestion.

    I do have =AQ20/((DATE(2010,12,31)-TODAY())/30.4166)

    and =YEAR(NOW())-1970

    and =YEAR(NOW())-1947

    but I have the same spreadsheet as *.ODS in OO Calc and that doesn't ask for save.

    I can't make it Read Only as it is altered daily and opened just for ref. 1 or more times a day.
    Thats actually a cronic failure of OO.

    Today should be re-evaluated if you have automatic calculation turned on.
    throw new ArgumentException (String, String, Exception)

  9. #8
    Senior Member watercooled's Avatar
    Join Date
    Jan 2009
    Posts
    11,459
    Thanks
    1,539
    Thanked
    1,022 times in 868 posts

    Re: Excel asking to save but...

    Quote Originally Posted by SiM View Post
    No selecting another cell doesn't. Another solution is to disable the save prompt for that book. There is an option in vba to do this iirc.
    Did last time I used Excel.

  10. #9
    Senior[ish] Member Singh400's Avatar
    Join Date
    Jun 2008
    Posts
    2,933
    Thanks
    136
    Thanked
    310 times in 247 posts

    Re: Excel asking to save but...

    Quote Originally Posted by watercooled View Post
    Did last time I used Excel.
    Just checked, and it didn't for me.

  11. #10
    Senior Member watercooled's Avatar
    Join Date
    Jan 2009
    Posts
    11,459
    Thanks
    1,539
    Thanked
    1,022 times in 868 posts

    Re: Excel asking to save but...

    Maybe a different version then.

  12. #11
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,164
    Thanks
    803
    Thanked
    2,152 times in 1,408 posts

    Re: Excel asking to save but...

    Quote Originally Posted by watercooled View Post
    Maybe a different version then.
    see my whole section on volatile formula in cells.
    throw new ArgumentException (String, String, Exception)

  13. #12
    Senior Member watercooled's Avatar
    Join Date
    Jan 2009
    Posts
    11,459
    Thanks
    1,539
    Thanked
    1,022 times in 868 posts

    Re: Excel asking to save but...

    Yeah it's probably that I was just saying it could have been if a different cell was highlighted.

  14. #13
    Senior[ish] Member Singh400's Avatar
    Join Date
    Jun 2008
    Posts
    2,933
    Thanks
    136
    Thanked
    310 times in 247 posts

    Re: Excel asking to save but...

    Quote Originally Posted by TheAnimus View Post
    see my whole section on volatile formula in cells.
    Spot on. Just checked =TODAY() and it does indeed prompt you to save it, even if you haven't changed anything.

  15. #14
    Senior Member Giraffe's Avatar
    Join Date
    Feb 2007
    Location
    near Northampton
    Posts
    841
    Thanks
    34
    Thanked
    39 times in 34 posts
    • Giraffe's system
      • Motherboard:
      • Gigabyte GA-Z97-D3H
      • CPU:
      • Intel Core i5 5675C, S 1150, Broadwell, Quad Core, 3.1GHz, 3.6GHz Turbo
      • Memory:
      • Crucial Ballistix DDR3 1600, 4GB
      • Storage:
      • 512GB Samsung SSD, 850 Pro, SATA 3
      • Graphics card(s):
      • Integrated
      • PSU:
      • Seasonic S12G 450W 80+ Gold
      • Case:
      • Antec P100
      • Operating System:
      • Windows 7 Pro, 32-bit
      • Monitor(s):
      • Dell U2415, 24", 16:10
      • Internet:
      • TP-Link modem-router; 3mbps sync.

    Re: Excel asking to save but...

    Quote Originally Posted by SiM View Post
    Turn automatic calculation off. If you are a serious spreadsheet user then you shouldn't be using automatic calculation - it's for n00bs.

    I will introduce you to your new best friend: Shift+F9
    Yes, that works, thank you SiM.

    Looks as if F9 alone will also do it. Now have to get used to Enter then F9.

    BTW, serious I am not! After 15 years of using comples databases, I cobbled together a couple of spreadsheets for the first time earlier this year. They do what I want and I don't really want to know how, as the more questions I see about Excel the more confusing I find it. If I really needed to use all the gubbins then I'd learn them, but with my memory...!
    PeterC

    Political lubricant:

    Rocket WMD45

  16. #15
    Senior Member Giraffe's Avatar
    Join Date
    Feb 2007
    Location
    near Northampton
    Posts
    841
    Thanks
    34
    Thanked
    39 times in 34 posts
    • Giraffe's system
      • Motherboard:
      • Gigabyte GA-Z97-D3H
      • CPU:
      • Intel Core i5 5675C, S 1150, Broadwell, Quad Core, 3.1GHz, 3.6GHz Turbo
      • Memory:
      • Crucial Ballistix DDR3 1600, 4GB
      • Storage:
      • 512GB Samsung SSD, 850 Pro, SATA 3
      • Graphics card(s):
      • Integrated
      • PSU:
      • Seasonic S12G 450W 80+ Gold
      • Case:
      • Antec P100
      • Operating System:
      • Windows 7 Pro, 32-bit
      • Monitor(s):
      • Dell U2415, 24", 16:10
      • Internet:
      • TP-Link modem-router; 3mbps sync.

    Re: Excel asking to save but...

    Quote Originally Posted by TheAnimus View Post
    Thats actually a cronic failure of OO.

    Today should be re-evaluated if you have automatic calculation turned on.
    Actually OO Calc does update Today(). I have figures calculated for Days, Weeks and Months to the end of this and next years plus 'tomorrow' and those and the number of days left and the dates under the 2 columns all update on opening but no Save is demanded if I don't change a figure.
    PeterC

    Political lubricant:

    Rocket WMD45

  17. #16
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,164
    Thanks
    803
    Thanked
    2,152 times in 1,408 posts

    Re: Excel asking to save but...

    Quote Originally Posted by Giraffe View Post
    Actually OO Calc does update Today(). I have figures calculated for Days, Weeks and Months to the end of this and next years plus 'tomorrow' and those and the number of days left and the dates under the 2 columns all update on opening but no Save is demanded if I don't change a figure.
    Indeed this is why no one takes OO seriously. I hope there is an option to correct this behavoir. The state of the sheet, as viewed by someone has changed.

    If someone has auto calc off, they want to know the last state someone used it in.

    If someone dosen't want a sheet to have changes saved, they mark it readonly.
    throw new ArgumentException (String, String, Exception)

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Vlookup not working (sort of)
    By piggeh in forum Help! Quick Relief From Tech Headaches
    Replies: 9
    Last Post: 03-09-2010, 04:35 PM
  2. Replies: 12
    Last Post: 01-06-2008, 10:30 PM
  3. .NET Reading Multiple Excel Files
    By Shadow_101 in forum Software
    Replies: 5
    Last Post: 23-11-2007, 03:22 PM
  4. Excel + Database + Automated
    By Kezzer in forum Software
    Replies: 4
    Last Post: 29-03-2007, 04:54 PM
  5. Replies: 6
    Last Post: 12-08-2005, 08:50 AM

Posting Permissions

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