Question about Microsoft Office Excel 2003 for PC
I make my invoices of about 50-80 rows x 12 columns in Excel. Normally, till one year ago the average file size was about 20KB. But since a year, my laptop started throwing problems in Excel. My file sizes started ballooning ..every new file saved was between 5 - 30 MBs! Working on these saved files have become impossible..as they are too slow, and often hang while performing a function..I have tried many anti virus programs, and tune ups for the computer..the same problems..no change!!!
I was using Windows XP .. so used to save files in the 97-2003 format. I wondered if that was the problem and started saving them in Auto format..no improvement. Then I tried deleting, the borders and colourings..in the end deleted all data in a file to see if this was increasing the size..no significant change in the file size.Just saving a blank sheet was making it so abnormally heavy.
Then I downloaded these files into my new notebook which had Excel 98 version...the same problems here too! Then I re-installed Excel, latest version..but no results !!!
Although I am not using Microsoft Word all that much I have not seen any problems there. Though right in the start before I had done those virus scans and re-installations..Word had showed some problems with speed. But there has been no problems there lately ..so it looks like an Excel problem.
What can I do? Can you help?
Whenever Excel closes unexpectedly, "ghost users" can remain in a "shared" workbook. Excel tracks changes in order to synchronize between users, resulting in huge file sizes. In order to fix the problem click Share Workbook (Review tab, Changes group in 2007 or Tools/Share Workbook in earlier). On the Editing tab see if there are any "Users" using the workbook. If so, remove them by clicking "Remove User." When you save again, the file should be back to normal. Being this is a Microsoft product, I want to re-emphasize the word "should" from my previous sentence...
Posted on Jan 05, 2009
I had the same problem too.. but what i did is to open Access, import the excel file data then copy it to a new sheet & re-do the formatting....
If I copied anything from the problematic excel file and paste it to a new file, the problem will still persist.
Posted on May 17, 2012
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Aug 14, 2013 | Microsoft Office Business & Productivity...
on Jul 27, 2010 | Microsoft Excel for PC
Apr 22, 2013 | Microsoft Office Professional 2010
Apr 22, 2013 | Microsoft Office Business & Productivity...
Dec 31, 2009 | Microsoft EXCEL 2004 for Mac
Aug 19, 2009 | Microsoft Office Excel 2003 for PC
Mar 15, 2009 | Microsoft Excel for PC
Jan 14, 2009 | Microsoft Excel for PC
Jan 06, 2009 | Microsoft Excel for PC
7,178 people viewed this question
Usually answered in minutes!
Level 3 Expert
Level 3 Expert
Level 3 Expert
Step 2: Please assign your manual to a product: