troubleshooting Question

Excel 2007 Save and Save As Problems

Avatar of ScuzzyJo
ScuzzyJoFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft OfficeWindows NetworkingMicrosoft Excel
18 Comments3 Solutions645 ViewsLast Modified:
Hi

I'm having difficulty saving Excel files, both in 2007 and 97-2003 formats.  Some of the files are quite large, but not ridiculously so.  Excel frequently hangs during the save operation and, even when it does manage it, it's still really slow.  The problem is worse when saving across the network, but pretty bad when saving locally.  It's quicker if all the file links are broken but, obviously, this is not feasible for many files.  Typically, Excel crashes on me 5 or 6 times a day - more on manic reporting days.

I have heard/read various comments about it being caused by the Microsoft Office Validation, a security update, and so on.  I've also seen lots of pages that suggest registry changes.

I do remember that in my last role, the I.T. department came round and took one of the Microsoft updates off the machines to resolve this (can't remember which one).

Does anyone have a definitive answer that will definitely solve this?  The problem seems to apply to Access too, though that might be for a completely different reason.

I don't have administrator rights on this machine (damn them!) but if I have some kind of good reason why they should go down a particular path, I think I.T. will be prepared to try it.

I'm awarding 500 points, but won't be able to award them until the solution has been tried, tested and proved to work, so it may take a couple of days.

Thanks
Sarah
ASKER CERTIFIED SOLUTION
joyofsharing

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros