Skip to main content

AutoRecover in Office 2000

A customer of mine recently had a problem with Excel 2000 – yes lots of people are still using Office 2000 as it’s very fast and does most of what they need.  It had crashed and they hadn’t saved their changes in a few hours.

Now, if this had been Office 2003/2007 the next time they opened Excel it would have prompted them with an “AutoRecovered” version of their file.  By default Excel 2003/2007 AutoRecover an open worksheet every 10 minutes – this can be changed.

But this didn’t seem to be the case with Excel 2000.  I had thought it was available in Excel 2000 but nothing could be found in Tools | Options.  It was there in Word 2000 in Tools | Options | Save so what was the deal?

Turns out that, by default, AutoRecover isn’t installed in Excel 2000. It’s there as an Add-In.  You must first install the Add-In by going to Tools | Add-Ins and choosing the “Autosave” Add-In.  Once this installs you’ll see the Autosave option in the Tools menu.  Clicking it will allow you to configure the time interval and whether all sheets or just the active sheet should be accounted for.

How bizarre, and how frustrating for my customer, that this feature was available but not put there by default.  Very annoying.

Comments

Unknown said…
Interesting and beautiful blog lovely presentation thanks for sharing your views. please keep this...

we24support@1 888 399 9656
we24support
we24support-webeden
20 June 2012 at 08:56
Post a Comment

Popular posts from this blog

Resolve WSUS Server issue that gives "Cannot save configuration because the server is still processing"

This is a pretty infuriating error and can sometimes crop up as a result of running a "wsusutil reset" command. First of all, give the server some time, and then a bit more...  but you've probably already done this. These steps may help to resolve the situation: - Install Microsoft SQL Management Studio (free download) - Run SQL Management Studio and start to connect to the WSUS database - Enter this in the "Server Name" box:  \\.\pipe\MICROSOFT##WID\tsql\query - Expand the "Databases" tree - Right-click on "SUSDB" and choose "New Query" - Paste this query in:     UPDATE tbSingletonData     SET ResetStateMachineNeeded = 0 - You should see a message like "1 row affected", which is good - Quit SQL Management Studio - Open "Services" and restart the "WSUS Service" - Now, open WSUS
Post a Comment
Read more

Evolution MK-249C MIDI Keyboard Mac OS X Problem

Mac OS X generally seems capable of dealing with just about anything you can throw at it. However upon connecting my trusty Evolution MK-249C MIDI keyboard up to my 2nd generation MacBook it steadfastly refused to play ball. This keyboard has always been instantly recognised by Windows XP and so it was surprising to encounter this. The M-Audio website (M-Audio took over Evolution it appears) offered no real assistance. There was no driver available for Mac OS X 10.4.9 as the keyboard is supposed to be "Class Compliant" which apparently means it doesn't need one... strange. Eventually after consulting some forums I found the fix. The problem seems to be related to Mac OS on the Intel MacBooks. There is a patch on the M-Audio site but only for MacOS 10.1.5. This must be downloaded and installed. Here is the link: http://www.m-audio.com/index.php?do=support.drivers&f=596 Upon restarting the OS the keyboard was recognised by Mac OS and GarageBand had no trouble tal...
11 comments
Read more

Jamf Pro DEP Enrollment Sync failed: Communication error. Awaiting next sync

 This error catches me out every so often when a customer of mine gets new iPads and I have to enrol them.  It's often been some time since I've last done this job and sometimes the MDM Server token needs to be refreshed (for want of a better term) before sync can re-commence between Apple School Manager and the customer's MDM (in this case Jamf Pro). Here are the list of steps to take: Log in to Apple School Manager (ASM) in one browser tab, and your MDM in another tab. In ASM, click your account name on the bottom left, and click "Preferences". Under "Device Management Services" click on your MDM service (Jamf Pro in my case). Click "Download Token" and allow the p7m file to download. In your MDM service, you'll need to upload the p7m file into its "Server token file" area. In Jamf Pro, click into "Settings" and then go into "Automated device enrollment", which is in the "Global Management" area. Cl...
Post a Comment
Read more