New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Running Windows (or anything else) on your Mac Discussion of Classic or running Windows, Linux and other OSes on the Mac.

Windows - MS Office - auto save


Post Reply New Thread Subscribe

 
Thread Tools
bobtomay

 
bobtomay's Avatar
 
Member Since: Dec 22, 2006
Location: Texas, where else?
Posts: 25,017
bobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond repute
Mac Specs: 15" MBP 2.33 C2D 256 4GB, MBA 13" i7 1.8, MB 2.0 2GB, Nano 4th, 3GS, iPad 1

bobtomay is offline
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.
QUOTE Thanks
McBie

 
McBie's Avatar
 
Member Since: Apr 26, 2008
Location: Belgium
Posts: 2,290
McBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to all
Mac Specs: 2013 MBA 13" - 10.9.3 & iPad - iOS 5.1

McBie is offline
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 problem is not the problem. The problem is your attitude towards the problem. You understand ?
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 39,437
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is offline
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
QUOTE Thanks
bobtomay

 
bobtomay's Avatar
 
Member Since: Dec 22, 2006
Location: Texas, where else?
Posts: 25,017
bobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond repute
Mac Specs: 15" MBP 2.33 C2D 256 4GB, MBA 13" i7 1.8, MB 2.0 2GB, Nano 4th, 3GS, iPad 1

bobtomay is offline
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.
QUOTE Thanks
McBie

 
McBie's Avatar
 
Member Since: Apr 26, 2008
Location: Belgium
Posts: 2,290
McBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to all
Mac Specs: 2013 MBA 13" - 10.9.3 & iPad - iOS 5.1

McBie is offline
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 problem is not the problem. The problem is your attitude towards the problem. You understand ?
QUOTE Thanks

Post Reply New Thread Subscribe


« How to install "Classic" on Intel MBP | Sound? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Question about Bootcamp Melorock089 Switcher Hangout 12 06-29-2009 07:53 PM
Mac Office Suite Choices-Office08/NeoOffice3/iWork09...what do YOU recommend? PKGuy323 Switcher Hangout 6 05-18-2009 05:42 PM
Big Switch Office for Windows to Office Mac Z4MC Switcher Hangout 8 04-29-2008 04:43 AM
Switcher Article in Today's Times studio34 Switcher Hangout 9 08-11-2006 03:10 PM

All times are GMT -4. The time now is 04:51 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?