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:
Apr 22, 2013 | Microsoft Office Professional 2010
Apr 22, 2013 | Microsoft Office Computers & Internet
Nov 15, 2010 | Microsoft Windows XP Professional
Feb 17, 2010 | Computers & Internet
Dec 31, 2009 | Microsoft EXCEL 2004 for Mac
Aug 19, 2009 | Microsoft Office Excel 2003 for PC
Jul 15, 2009 | HP OfficeJet 6110 All-In-One InkJet...
Mar 15, 2009 | Microsoft Excel for PC
Feb 26, 2009 | Microsoft Excel 2000 Step by Step...
Apr 19, 2018 | Ricoh Computers & Internet
7,192 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: