Google Translate

Wednesday, January 28, 2009

SOLUTION: misconfigured "TemporaryItems" folder makes Office:Mac 2004 inoperable

This soluion has to do with a bad Mac OS X "TemporaryItems" folder that causes Microsoft Office:Mac 2004, including Word 2004 and Excel 2004, to consistently give error messages and refuse to work normally. I'm writing this down because it's a solution that I was unable to locate through a Google search or haven't seen documented anywhere by anyone. (If it's the latter, I'd be really surprised!)

(Note: the error messages listed are mostly correct in wording/phrasing as what the programs reported. Unfortunately, I didn't screenshot or write them down.)

My computer set-up: PowerPC-based Mac running Mac OS X 10.4.11.

A. Microsoft Excel:Mac 2004
A few days ago, when I started Excel:Mac 2004 by double-clicking an XLS file, it gave this error:

'filename.xls' could not be found.

Check the spelling of the file name and verify that the file location is correct.

If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved or deleted.
This was particularly distressing because it's a file that I use everyday and Excel had never had an hang-ups about opening it.

When I tried to open the file manually in Excel (i.e. through File->Open), I got the same error upon pressing the "Open" button.

I decided to try and create a new file. This time, I got a new error message:
Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space.

To make more memory available, close workbooks of programs you may no longer need.

To free disk space, delete files you no longer need from the disk you are saving to.
This was even stranger because I had gigabytes of space in my hard disk. Something else was wrong here.

B. Microsoft Word:Mac 2004
To double-check, I tried using Word:Mac 2004. Starting it up was fine, but when I tried to open a file, I encountered this error message:
'filename.doc' is being used by 'another user'. Do you want to make a copy?
This was impossible since I was using the one-and-only OS X user account and the file I was opening had never been opened by anyone else or been closed improperly. Like before, I tried creating a new file, and now Word complained:
Do you want to replace the existing "Normal"?
I hit "Cancel" to skip the error, which leaves me in Word. So I closed Word again and now it said:
Changes have been made that affect the global template "Normal". Do you want to save those changes?
Of course, I pressed "Don't save".

Based on the above experience, I surmised that my problem couldn't be restricted to Excel or Word (or PowerPoint, for that matter). It was something more global.

Solution: ensure that there is a working "Home/Library/Caches/TemporaryItems" folder
When working with its DOC/XLS/PPT/whatever files, Office:Mac 2004 needs a place to save the working copies for its own use. These working copies, or temporary files, reside in the location, "Home/Library/Caches/TemporaryItems". If this folder is misconfigured or corrupt, none of the Office:Mac 2004 programs (Word:Mac 2004, Excel:Mac 2004, PowerPoint:Mac 2004, etc) will work.

To recreate a working copy of "Home/Library/Caches/TemporaryItems",
  1. Delete "TemporaryItems" folder in "Home/Library/Caches", if it's there.
  2. Delete "Home/Documents/Microsoft User Data/Entourage Temp"
  3. Start any Office:Mac 2004 program (Word:Mac 2004, Excel:Mac 2004, PowerPoint:Mac 2004. etc.)
You should now have a working "Home/Library/Caches/TemporaryItems" folder and Office:Mac 2004's programs (Word:Mac 2004, Excel:Mac 2004, PowerPoint:Mac 2004, etc.) should not give any error messages.

You can stop reading here, if you want to. What follows is my (long!) list of attempted solutions.

Attempted Solution #1: delete preference files
In Mac OS, deleting the preference files is usually the first and easiest step to solve any problem. So I deleted the Office-related files in "Home/Library/Preferences" and "Home/Documents". No luck there.

Attempted Solution #2: check for corrupt fonts
When I had encountered weird Office:Mac 2004 errors previously, the culprit was usually some corrupt font. So I used Mac OS X's Font Book to deactivate all fonts, then restarted Word or Excel. Nope, the problem was still there.

Attempted Solution #3: repair system permissions and repair disk
Another cure-all in the Mac OS X world: use Disk Utility to repair permissions and the disk itself. Though it's never been proven, repairing sometimes solves problems. Unfortunately, though Disk Utility found a problem with my disk's volume header, Word and Excel still refused to run.

Attempted Solution #4: re-install Office:Mac 2004
Based on some searches, a problem in a required Office installation file could be a problem-maker. The easiest way to solve it was to re-install the whole software. So I did. Luckily, it didn't take more than half an hour. Alas, the problem persisted with this clean installation, even after adding the updates.

Attempted Solution #5: re-install Mac OS X 10.4
This was the last resort and it took me about three hours to get my Mac OS X environment restored to the way it was originally. (Reinstalling the operating system, including the updates, took about an hour. Copying files and reinstalling other software took about another hour.)

And success! It worked! No more error messages in Word:Mac or Excel:Mac. My trusty ol' DOC and XLS files opened as usual with no problems. And no other weird messages on quitting.

I was content to leave this as it was... until it happened again. Aaargh!

Now I had to remember what I'd done since it stopped working properly. Had I installed any new software in the last few days?

Attempted Solution #6: downgrade QuickTime from 7.6 to 7.5.5
QuickTime 7.6 was one new software. I had read of some software conflicts with it, but nothing related to Office:Mac 2004. Still, there was no harm in downgrading and trying it. Alas, it did not eliminate the problem.

Attempted Solution #7: create a new OS X user
Another "last resort" solution. I created a new user, logged into it, then started Excel and Word. Both worked flawlessly! This narrowed the problem down to some files within my "Home/Library" folder, since each user has its own Library.

Comparing files/folders between the two, I couldn't find anything that was different. My original "Library" folder had the same essential contents as the new user's. So I copied files/folders out of my original "Library" folder. No luck, I still had the Excel and Word errors.

Attempted Solution #8: delete contents of "Home/Library/Caches"
And then I stumbled upon this quite by accident: while copying files back into my original "Library" folder, I decided to not copy the "Home/Library/Caches" folder. Which meant that the "Caches" folder in my original "Library" folder was now empty.

And Word and Excel started with nary a complaint!

I then used a couple of other programs, then tried to start Excel. The problem returned! I went through the programs I'd used and two stuck out: Safari and Firefox.

Attempted Solution #9: remove Safari's caches
Safari had recently been upgraded to version 3.2.1, another new piece of software. Unfortunately, removing its stuff in the "Caches" folder did not eliminate the problem.

Attempted Solution #10: disable Firefox's add-ons/plug-ins
Starting Firefox 3.0.5, I disabled all of its add-ons. In its "virgin" state, I knew from past experience that it couldn't be messing up the "Caches" folder. Unfortunately, this didn't work... until I decided to just see what was inside the "Caches" folder itself.

Attempted Solution #11: delete misconfigured "TemporaryItems"
I found one strange item: "TemporaryItems". It was a folder, but was not "working" as a folder, i.e. I couldn't list its contents. So I deleted it, then restarted Excel. No go. However, I found through trial-and-error that I could recreate a "proper" "TemporaryItems" folder by deleting "Home/Documents/Microsoft User Data/Entourage Temp". I don't know how/why it works, but it does.

While leaving the "TemporaryItems" folder open, I started Excel by double-clicking an XLS file. Excel worked perfectly well again! And now I noticed that it had creating a temporary file in the "TemporaryItems" folder.

Of course! Word and Excel had complained of low memory or all of the other crap errors because it couldn't save its temporary working files!

True Solution: remove software that misconfigure "TemporaryItems"
I later found out that it was an erroneous Firefox add-on, Weave 0.2.7, which had caused all of these problems. Apparently, it was either deleting incompletely the "TemporaryItems" folder or was creating it improperly. Whatever the reason, it was messing up my system badly. Needless to say, I'm keeping it disabled.

I hope the above is useful for anyone who encounters the same problems as me. Hopefully, I've stuffed enough keywords to make it easily searchable.



Anonymous said...

You rock! This solved my problem, and I have to use Excel for an exam this week. Thanks.

Yuhui said...

No problem, glad I could help!

Acey Aquino said...

Nice share. I use an alternative tool "Long Path Tool" guarantees to fix your error fast and easy.

Unknown said...

after a long time troubleshooting this, I came across this link and your solution fixed my problem. Many, many, many thanks !!

Post a Comment