Excel Acting Unusually Slow?
Posted by: Ralph van den Berg (27 October, 2009)
This sounds ridiculous, and I'm sure Microsoft has addressed this problem in later versions of office, but if you found this page, it's probably happening to you. Some of the symptoms or areas in which Excel slows down drastically is simple cell formatting or row / column insertion. Actions that would usually take less than a second take minutes and it becomes really frustrating when you search Google and the answers are all misleading. I've found things ranging from cells apparently empty being laden with data to broken relations. None of this was applicable. It happened even when you opened a new file, and the same files opened on another PC had no problems at all. This is reason enough to assume that the problem was with the computer and not the files.
The culprit is your (default) printer, or in this case, lack thereof. It seems excel is really obsessed with keeping track of your printer, and if it can't find it then you get disastrous performance. Check to see if your default printer is on and connected. If it's a printer connected to a different computer on a network, check if that computer's on and properly sharing the printer. If all else fails, change your default printer to something not dependent on external hardware, like a PDF document maker.
Now try some simple cell formatting or insert a new column. If the problem is fixed, you're welcome. Otherwise, I'm sorry- keep Googling.
Share< Please log in or register to post comments >
Next Rambling »
Google Maps Navigator« Previous Rambling
How much do you read?Related Ramblings
- Getting Started with Dropboxposted by Ralph van den Berg
on 1 Jun, 2010 - Getting Started with Torrentsposted by Ralph van den Berg
on 23 Apr, 2010 - Apple Snow Leopard Wallpapersposted by Ralph van den Berg
on 10 Aug, 2009 - A few handy Firefox tipsposted by Ralph van den Berg
on 6 Jul, 2009 - Old Games Not Deadposted by Ralph van den Berg
on 31 May, 2009 - Hidden Windows 7 Wallpapersposted by Ralph van den Berg
on 24 Apr, 2009 - Download Windows 7 Wallpapersposted by Ralph van den Berg
on 23 Mar, 2009 - Get Firefox 3.1 beta 3 nowposted by Ralph van den Berg
on 12 Mar, 2009 - Alternative Win7 Wallpaperposted by Ralph van den Berg
on 4 Mar, 2009 - On-The-Road Cookingposted by Ralph van den Berg
on 19 Jan, 2009 - My Windows 7 Experienceposted by Ralph van den Berg
on 14 Jan, 2009 - Give Me Deathposted by Ralph van den Berg
on 16 Oct, 2008 - Best Headache Remediesposted by Ralph van den Berg
on 7 Aug, 2008 - Cutting Up a Dog on Fireposted by Kendall Meade
on 12 Jul, 2008 - Firefox IS Betterposted by Ralph van den Berg
on 10 Jun, 2008
Recent Activity
16 Aug, 2010: Ralph van den Berg
commented on Crap, the Future
"There are a couple of groups who are desperately trying to "save the wave" after Google announced that it would wave goodbye to that project. All puns inte[...]"
commented on Crap, the Future
"There are a couple of groups who are desperately trying to "save the wave" after Google announced that it would wave goodbye to that project. All puns inte[...]"
31 Jul, 2010: Ralph van den Berg
commented on Text to Movie - A Blonde, Donkey, Yankees and Bats
"That's how I came upon Xtranormal. There's also the rebuttal video, easily found in the related video's section in Youtube. Check them out. I also encourag[...]"
commented on Text to Movie - A Blonde, Donkey, Yankees and Bats
"That's how I came upon Xtranormal. There's also the rebuttal video, easily found in the related video's section in Youtube. Check them out. I also encourag[...]"
31 Jul, 2010: Antonius L. Zubeck
commented on Text to Movie - A Blonde, Donkey, Yankees and Bats
"Yes it's like the iPhone 4 vs HTC EVO video nearly got an employee fired over it! http://www.youtube.com/watch?v=FL7yD-0pqZg"
commented on Text to Movie - A Blonde, Donkey, Yankees and Bats
"Yes it's like the iPhone 4 vs HTC EVO video nearly got an employee fired over it! http://www.youtube.com/watch?v=FL7yD-0pqZg"
24 Jul, 2010: Antonius L. Zubeck
commented on Stuff I found layout around the web
"Haha, good stuff, keep it coming!"
commented on Stuff I found layout around the web
"Haha, good stuff, keep it coming!"
7 Jul, 2010: Antonius L. Zubeck
commented on Striving for Carbon Neutrality
"I'm thinking the extra weight of the dirt and bricks may have a negative impact on fuel consumption and thus on the environment. We're gonna need some wiza[...]"
commented on Striving for Carbon Neutrality
"I'm thinking the extra weight of the dirt and bricks may have a negative impact on fuel consumption and thus on the environment. We're gonna need some wiza[...]"
External Links
RalphvandenBerg.com [version.3]
Copyright © 2008 - 2010
Website by Ralph van den Berg
All rights reserved
Sitemap
contact me
Copyright © 2008 - 2010
Website by Ralph van den Berg
All rights reserved
Sitemap
contact me