Question about Microsoft Excel for PC

1 Answer

Weird Excel problem creates oversized files

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.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 145 Answers

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.

Posted on Jan 14, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Excel 2003 worksheet slow in 2007


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.

Mar 25, 2014 | Microsoft Office Professional 2007 Full...

1 Answer

How i can crack the password of excel sheet..............


Hi,

Have tried downloading the password.xla? If not, below is the link:

http://www.straxx.com/excel/password.html

Just add this xla to your addins and then open your excel document. The sheet will be automatically be unprotected.

Feb 09, 2011 | Microsoft Office Professional 2007 Full...

2 Answers

How to Open the Excel file 2003 in Office 2007?


You have to download this compatibility pack and instal it on your machine. Here is the link.

http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en

Jan 03, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

I have word2000 and i want to open a word 2oo7 document how can i


Download this tools for Microsoft:

http://www.microsoft.com/downloads/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en

Please note that:

Overview Users of the Microsoft Office XP and 2003 programs Word, Excel, or PowerPoint—please install all High-Priority updates from Microsoft Update before 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.

Administrators: The administrative template for the Word, Excel, and PowerPoint converters contained within the Compatibility Pack is available for download.

Update: The Microsoft Office Compatibility Pack Service Pack 1 (SP1) is available here.
arrow_px_up.gif Top of page
System Requirements
  • Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003; Windows Vista; Windows XP Service Pack 1; Windows XP Service Pack 2
  • Recommended Microsoft Office programs:
    • Microsoft Word 2000 with Service Pack 3, Microsoft Excel 2000with Service Pack 3, and Microsoft PowerPoint 2000 with Service Pack 3

    • Microsoft Word 2002 with Service Pack 3, Microsoft Excel 2002 withService Pack 3, and Microsoft PowerPoint 2002 with Service Pack 3

    • Microsoft Office Word 2003 with at least Service Pack 1, MicrosoftOffice Excel 2003 with at least Service Pack 1, and Microsoft OfficePowerPoint 2003 with at least Service Pack 1

    • Microsoft Office Word Viewer 2003

    • Microsoft Office Excel Viewer 2003

    • Microsoft Office PowerPoint Viewer 2003

arrow_px_up.gif Top of page
InstructionsTo install this download:
  1. 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).

  2. 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.

  3. Double-click the FileFormatConverters.exe program file on your hard disk to start the setup program.

  4. Follow the instructions on the screen to complete the installation.

To remove this download:

  1. On the Windows Start menu, click Control Panel.

  2. Select Add/Remove Programs.

  3. 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.

  4. Click Yes or OK to confirm that you want to remove the program.

P.S.: If this information was helpful, please rate this solution.


Mar 23, 2009 | Microsoft Office Professional 2007 Full...

4 Answers

My excel sheet is not opening


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

Dec 28, 2008 | Microsoft Excel 2003 (06503995)

1 Answer

Excel wont open the file?


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

Oct 08, 2008 | Microsoft Excel for PC

1 Answer

EXEL 2007


This is because 2007 excel uses a different type of file. You may follow the directions at the link below on how to save files in 2007 excel so that you can open it in 2003


http://office.microsoft.com/en-us/excel/HA100141071033.aspx

If there is anything else please do message me.

Sep 25, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

Sharing Problem


some colors are not available in office 2003

under (office 2007) excel options (alt-t-o), save tab, you can choose which colors will be seen in previous excel versions.

Sep 23, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

2007 version running SLOW!!


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! ---- JG

Jun 21, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

137 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...