I am having a problem with an Excel file on an XP Home machine running Office 2003. I have an excel file that has 9 different sheets on it, each not being more than 40X40 cells. I am using an almost identical file on 15 different machines, and this is happening only on one machine. The typical file size is betweeen 200k-300k on all machines, but on this particualr machine, the size is at 10Mb. There is nothing out of the ordinary on this file. Here's where I am getting concerned though. When I open the file, which by the way seems to take about 10-15 seconds to open, (the other terminals all open instantly) and select all sheets, copy them to a new excel book, and then save that book, the file size goes back to the normal 200k-300k size. If I close everything out and open the new file, it opens instantly without the lag. WHAT CAUSES THIS!!! Thanks for your help.
An expert who has achieved level 2 by getting 100 points
An expert that got 5 achievements.
An expert whose answer got voted for 20 times.
An expert who has written 20 answers of more than 400 characters.
Re: Weird Excel problem creates oversized files
You have already find the solution by copying its contents to some other file. There can be a possibility that some virus has attached itself to the said file. Use a good anti virus and update is regularly.Another possibility is that you might have many of the rows or colums which you may have not noticed. Please rate me appropriately if you are satisfied with my answer,in case, if you want any clarification please get back to me.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Hi Lee, I have recently experienced the same thing. When Excel 2007 or later opens an Excel 97-2003 .xls file, there are major issues of speed. The file is opened in compatibility mode. The best thing to do would be to open the file, then save as (keep the same name if you like) an Excel 2007 .xlsx document (or .xlsm document if there are macros). Close the file, then reopen it, and the compatibility mode issue will be gone. You can now use the newly saved file as a normal Excel 2007 file. Hope this helped.
Users of the Microsoft Office XP and 2003 programs Word, Excel, or PowerPoint—please install all High-Priority updates from Microsoft Updatebefore downloading the Compatibility Pack.
By installing the Compatibility Pack in addition to Microsoft Office2000, Office XP, or Office 2003, you will be able to open, edit, andsave files using the file formats new to Word, Excel, and PowerPoint 2007.The Compatibility Pack can also be used in conjunction with theMicrosoft Office Word Viewer 2003, Excel Viewer 2003, and PowerPointViewer 2003 to view files saved in these new formats. For moreinformation about the Compatibility Pack, see Knowledge Base article 924074.
Note: If you use Microsoft Word 2000 or Microsoft Word 2002 to read or write documents containing complex scripts, please see http://support.microsoft.com/kb/925451 for information to enable Word 2007 documents to be displayed correctly in your version of Word.
Ensure your system is up to date by installing all High-Priority/Required updates on Microsoft Update(required for Microsoft Office XP and 2003 users).
After installing all High-Priority/Required updates with Microsoft Update, download the Compatibility Pack by clicking the Download button above and saving the file to your hard disk.
Double-click the FileFormatConverters.exe program file on your hard disk to start the setup program.
Follow the instructions on the screen to complete the installation.
To remove this download:
On the Windows Start menu, click Control Panel.
Select Add/Remove Programs.
In the list of currently installed programs, select Compatibility Pack for the 2007 Office system and then click Remove or Add/Remove. If a dialog box appears, follow the instructions to remove the program.
Click Yes or OK to confirm that you want to remove the program.
P.S.: If this information was helpful, please rate this solution.
assuming you have Excel sw on your PC. Assuming you are running XP. Assuming you can start your Excel and Open any excel file using File/Open within excel.
You must associate Excel file with Excel program in your Windows Explorer. Fastest way is Browse to any excel file with your Windows explorer (NOT IE) Right click and select Open with... Browse to find your Excel MSOffice program Select Use always to use this program OK
Is it MS Office 2003 ?
Can you open Excel by clicking on it's icon?
If so, go to Control Panel>Add/Remove programs> scroll down to Microsoft Office 2003. Click on change. A box will open up and you and choose "repair and fix". Let it run . it should fix it.
If I could be of further assistance, let me know. If this helps or solves the issue, please rate it. Thanks, Joe
Are you trying to open a .xls file instead of an .xlsx file? Xlsx is the excel 2007 file format. Another cause could be a lack of free space on your hard drive. Uninstalling the 2003 version or defragging could do it. One last question: XP or Vista? I find Office 2007 works better with Vista. Good Luck!