Results 1 to 5 of 5
  1. #1
    Windows - MS Office - auto save
    bobtomay's Avatar
    Member Since
    Dec 22, 2006
    Location
    Texas, where else?
    Posts
    26,206
    Specs:
    15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '11 1.8 i7 4GB 10.10; 21" iMac '13 2.9 i5 8GB 10.10; 5s & 5c
    Windows - MS Office - auto save
    Figured someone here might have an answer, even if it's "just live with it".

    We have one computer that is only used for a single Excel workbook.. 15-18 pages in it - each page maybe 12 columns and 600 rows long.

    This is one of the 3 computers I use at work, but a total of 4 people input data into this single workbook on a daily basis - multiple times a day - this, is not going to change.

    The issue - I have the autosave function turned on.

    Is there a way to have the autosave turned on, but not autosave while I'm in the middle of typing and grinding to a halt for 30 seconds plus waiting for it? This is soooo annoying.
    I cannot be held responsible for the things that come out of my mouth.
    In the Windows world, most everything folks don't understand is called a virus.

  2. #2
    Windows - MS Office - auto save
    McBie's Avatar
    Member Since
    Apr 26, 2008
    Location
    Belgium
    Posts
    2,673
    Specs:
    2013 MBA 13" - OS X 10.10.5
    I see 2 options: ( and I am sure you have seen them as well )
    a) Switch autosave off and ask all 4 people to manually save each time they changed something -> a behavioral change
    b) " Just live with it "

    Sorry... I couldn't resist.

    Cheers ... McBie
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila.
    The bitterness of poor quality remains long after the sweetness of low price is forgotten.

  3. #3
    Windows - MS Office - auto save
    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    45,176
    Specs:
    27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, iPhone 6+, 3 iPods, Yosemite
    Yeah really, with very large worksheets and documents the autosave is going to interrupt for a few seconds. We notice it all the time especially with using Office 2010 on our PCs. The alternative of course is not to autosave and risk losing a large portion of your work if the system crashes (we're talking here about Windows not OS X).

    With four people updating that worksheet, there is no way I would even dare to suggest turning it off.

    As McBie says.... Se la vie

  4. #4
    Windows - MS Office - auto save
    bobtomay's Avatar
    Member Since
    Dec 22, 2006
    Location
    Texas, where else?
    Posts
    26,206
    Specs:
    15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '11 1.8 i7 4GB 10.10; 21" iMac '13 2.9 i5 8GB 10.10; 5s & 5c
    I figured as much. Although I work with Excel all day every day, it is very specialized and all are basically pre-formatted workbooks so I never really had to learn much more than merely to input data.

    Was just sort of hoping and was reminded about it after I saw the other post about auto save this morning.

    I finally got the boss to quit turning on the Windows auto update. Windows would decide to update while no one was around and reboot the system without saving the latest changes to the workbook - not a happy camper.

    (Had our IT guy in for a once every year or two visit about 3 months ago. I talked to him on the side and told him we needed a router/firewall/etc. Told him to pitch it good to convince the boss. Finally got to turn off that stupid McAfee firewall. All those problems have disappeared now.)
    I cannot be held responsible for the things that come out of my mouth.
    In the Windows world, most everything folks don't understand is called a virus.

  5. #5
    Windows - MS Office - auto save
    McBie's Avatar
    Member Since
    Apr 26, 2008
    Location
    Belgium
    Posts
    2,673
    Specs:
    2013 MBA 13" - OS X 10.10.5
    Looks like my latest reply was not posted ..

    Just talked to one of our IT girls and she said there is a way to detect keyboard and mouse idle status thru a VB script in excel.
    Disable autosave in excel by default.
    Have the VB script detect keyboard and mouse idle status and then enable autosave.
    When keyboard and mouse are in use, the VB script can disable autosave.

    I am not a programmer and this may be easier said than done, but it is an idea.

    Cheers ... McBie
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila.
    The bitterness of poor quality remains long after the sweetness of low price is forgotten.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto filter in Office: Mac vs PC
    By Trolle in forum OS X - Apps and Games
    Replies: 3
    Last Post: 01-24-2011, 01:01 PM
  2. ms word 2008 auto-save failed and question on RAM
    By lipgloss119 in forum Switcher Hangout
    Replies: 2
    Last Post: 01-19-2010, 09:15 PM
  3. QuickTime Pro 7 on Windows, Save/Save as grayed out?
    By zurih in forum Movies and Video
    Replies: 0
    Last Post: 10-24-2008, 11:02 AM
  4. Neo Office Auto Open
    By iag25 in forum OS X - Apps and Games
    Replies: 1
    Last Post: 11-21-2007, 09:28 PM
  5. Pages crashed - how to set up auto save?
    By rcronin in forum OS X - Apps and Games
    Replies: 0
    Last Post: 02-07-2007, 07:55 PM

Posting Permissions

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