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.
< 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 Disc Images and Clone Drivesposted by Ralph van den Berg
on 14 Sep, 2010 - 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
Recent Activity
2 Nov, 2011: Ralph van den Berg
commented on Tutorial on how to record Minecraft gameplay videos
"Note: Since Minecraft Prerelease 5, the F9 key is used for one of the new camera features. What I did was disable the default function for F12 in Fraps and[...]"
commented on Tutorial on how to record Minecraft gameplay videos
"Note: Since Minecraft Prerelease 5, the F9 key is used for one of the new camera features. What I did was disable the default function for F12 in Fraps and[...]"
19 Oct, 2011: Ralph van den Berg
commented on www.dearblankpleaseblank.com
"Dear comments, make your own list! Sincerely, the Rambling"
commented on www.dearblankpleaseblank.com
"Dear comments, make your own list! Sincerely, the Rambling"
19 Oct, 2011: Ralph van den Berg
commented on www.dearblankpleaseblank.com
"But this is a great place to have that list! Think about the comments being an extension to the actual Rambling!"
commented on www.dearblankpleaseblank.com
"But this is a great place to have that list! Think about the comments being an extension to the actual Rambling!"
18 Oct, 2011: Nathalie van den Berg
commented on www.dearblankpleaseblank.com
"haha you should make your own list! =]"
commented on www.dearblankpleaseblank.com
"haha you should make your own list! =]"
6 Oct, 2011: Ralph van den Berg
commented on www.dearblankpleaseblank.com
"Dear homework, they may be doing you but all they're thinking about is me. Sincerely, Summer."
commented on www.dearblankpleaseblank.com
"Dear homework, they may be doing you but all they're thinking about is me. Sincerely, Summer."
External Links
RalphvandenBerg.com [version.3]
Copyright © 2008 - 2012
Website by Ralph van den Berg
All rights reserved
Sitemap
contact me
Copyright © 2008 - 2012
Website by Ralph van den Berg
All rights reserved
Sitemap
contact me