Question about Microsoft Office Excel 2003 for PC

2 Answers

Microsoft Excel files: File size becomes very big while saving.

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?

Posted by on

  • 4 more comments 
  • Anonymous Dec 31, 2008

    No luck with options 1 and 2, have tried all that. But what is a macro? and what is an over sized one?

  • Anonymous Mar 17, 2009

    Same exact issue. Excel 2000, huge file size suddenly

    no macros, no ghost users, not a huge amount of data

    previous version of same doc is 5mb, current version of doc is almost 33mb

  • Anonymous May 03, 2009

    Some of my execel files have become bigger and are now slow to work on.

  • smartmind_25 May 11, 2010



    Macro is a external add-in ,R u pasting any screens or logos in your invoces?





    just disable all add ins(got ot tools menu --> add-ins Disable not required add-ins possiblly all)

    and turn of track changes

  • Peter Sturniolo
    Peter Sturniolo May 11, 2010

    Macros can be access via the Tools menu, or by pressing Alt+F8. Macros are essentially just a set of commands that run as a single operation. They should be less than 2 lines long.

  • Peter Sturniolo
    Peter Sturniolo May 11, 2010

    A couple things to check...


    1. Make sure there are no hidden rows or columns.

    2. Make sure there are no over-sized macros.

    3. Try deleting an entire row or column. (By right-clicking and selecting Delete from the drop menu, not by using the Delete button on the keyboard)

    Hopefully one of those options will make the file size smaller.

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers

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

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Cell freeze 3 rows together at a time.


Freeze a Row in Microsoft Excel
Microsoft Excel 2010 can freeze, or lock, a top row as you scroll down the worksheet.
For example, you may need to keep the top row of column titles visible at all times.
The "View" tab on the command ribbon contains the "Freeze Panes" button in the "Window" group.
A single row or a range of rows can lock through the "Freeze Top Row" or "Freeze Panes" options.

Open the Excel worksheet.
Click the top row heading.
The row heading displays a number just left of the first column of cells. The selected row appears shaded.


Click the "View" tab on the command ribbon.
Click the "Freeze Panes" button in the "Window" group.
A list of options appears.

Click the "Freeze Top Row" option.
A black horizontal line appears on the worksheet.
This line indicates the locked row that stays on the screen as you scroll down the worksheet.

http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP010342542.aspx?CTT=1
Freeze or lock rows and columns
also
Use Freeze Panes in Excel
Scrolling down to look at a number and then scrolling up to make sure the number you looked at is under the header you expected is not an efficient way to view a spreadsheet.
The Freeze Panes feature of Excel allows you to freeze the labels of your data in place while you review the data.
Follow the instructions in Section 1 to freeze the top row or the left column.
Freeze multiple rows, multiple columns, or rows and columns, by following the instructions in Section 2.Freeze the Top Row or Left Column
1
Open the Excel spreadsheet.
2
Navigate to the "View" tab on the top menu.


3 Click on "View," then click on "Freeze Panes." A drop-down menu opens.

4

Select the "Freeze Top Row" option to freeze the top row.

5

Select the "Freeze Left Column" or "Freeze First Column" option to freeze the left column.

6

Freeze the top row by using the keyboard and sequentially pressing the keys "ALT, W, F, R." Ignore Steps 3 through 7 if using this choice.

7

Freeze the left column using the keyboard by sequentially pressing the keys "ALT, W, F, C." Ignore Steps 3 through 7 if using this choice.

8

Unfreeze panes by repeating Steps 3 through 5 and selecting "Unfreeze Panes" or sequentially press the keys "ALT, W, F, F."

Freeze Rows and Columns, Multiple Rows, Multiple Columns, or Multiple Rows and Columns
9

Open the Excel spreadsheet.

10

Freeze column(s) and row(s) at the same time by selecting the cell to the right of and below the location you want to freeze.

11

Freeze multiple rows only by selecting the cell in the left (first) column below the rows you want to freeze.

12

Freeze multiple columns only by selecting the cell in the top row to the right of the columns you want to freeze.

13

Navigate to the "View" tab on the top menu.

14

Click on "View," then click on "Freeze Panes." A drop-down menu opens.

15

Select the "Freeze Panes" option. You have now frozen the columns or rows, or columns and rows you designated.

16

Freeze panes using the keyboard by sequentially pressing the keys, "ALT, W, F, F." Ignore Steps 5 through 8 if using this choice.

17

Unfreeze panes by repeating Steps 5 through 7 and selecting "Unfreeze Panes" or sequentially press the keys, "ALT, W, F, F."



http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx
Freeze or lock rows and columns
http://office.microsoft.com/en-us/excel-help/demo-hide-or-unhide-rows-and-columns-HA010241040.aspx
Hide or show rows and columns

Aug 14, 2013 | Microsoft Office Business & Productivity...

Tip

How to find no. of rows and columns in Worksheet.


Hello everybody, this would be my first tip on FixYa.com. Number of people might not be aware how many rows and columns are there in Microsoft Worksheet.
This is how you can find out.
1. Select A1 cell in the worksheet
2. Now press Ctrl + down arrow from your keyboard, that will take you to the bottom of the row. You can find the number on the left side.
3. Again select A1 cell in the worksheet and press Ctrl + left arrow from your keyboard, that will take you to the last column of the worksheet. Now to number, just type "=column() " , without quotations, that will give you the number of the column.
Microsoft Worksheet columns is number from A to Z, again from AA to AZ, again from BA to BZ and so on till it reached IV in Excell 2003 and earlier version.
Microsoft Excel 2003 and old version has 16,777,216 cells per worksheet (65,536 rows * 256 columns).
Excel 2007 has 17,179,869,184 cells per worksheet (1,048,576 rows * 16,384 columns).


on Jul 27, 2010 | Microsoft Excel for PC

2 Answers

Size of the excel file increased from 721 KB to 50MB


Many businesses use Excel to track their data and expenses.
However, you can run into problems when files grow too big.
Try reducing the size of your Excel files in different ways to eliminate your storage problems.
Remove unnecessary graphics and fonts from the Excel file.
Simple report data doesn't need a lot of excess formatting to make it attractive.
If you need to keep different fonts in your file, reduce some of the font sizes you originally used.
Reduce the number of pivot tables you allow in your data analysis.
Run your pivot table wizard when dealing with involved calculations.
When given options to format the file, choose those that allow the data to refresh instead of adding a new table.
Input your data, close the file and save as an Excel (XLS format) file and as an HTML (XML format) file.
To do this, choose "XML Data" in the "Save as type" drop down box.
Change the name of your document as well, so you can tell the difference between the two files.
Open the XML file and save it back into the regular XLS file to create a smaller file than the original.
Again, rename this file, as well as changing its type. This act removes odd programming left from past calculations since the last "save."
Check into file compression software such as OzGrid.
These products exist because you cannot open a file once it gets too big.
Compress the XLS data by compelling the program to recalculate the cells used for your file.

Excel File Size Reduce Software 7.0
http://www.newfreedownloads.com/Business/Spreadsheets/Excel-File-Size-Reduce-Software.html

http://www.ozgrid.com/

or

Microsoft Excel files can contain thousands of cells filled with data.
When you combine this information with graphics, such as charts and graphs, as well as ever-expanding links to other worksheets, you can end up with an enormous file that takes up precious system space and slows Excel down.
While there are many software programs available that promise to shrink Excel files, there are many ways to reduce the bulk without downloading a new application.

1. Click on any cell in the Excel file you want to reduce.
Open the "Go To" dialog box in Excel 2007 by clicking the "Find" drop-down arrow on the Home tab of the ribbon and selecting "Go To."
In Excel 2003 or earlier, go to the "Edit" menu and select "Go To."
You can also use the keyboard shortcut "Ctrl+G" in any version of Excel.
2. Click the "Special" button on the "Go To" dialog box.
Select "Blanks" and click "OK." Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All." This will clear any blank cells to help reduce the file size.


3. Go to the very last cell containing data in the Excel file.
Select the entire row beneath this cell by clicking the number to the left of it.
Hold "Ctrl+Shift" and then press the down arrow key to select all of the cells beneath this point.

4. Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All."
Select the column to the right of the last cell. Hold "Ctrl+Shift" and then press the right arrow key. Again, select "Clear All."
5. Repeat Steps 1 through 5 for any other Excel files that are linked to the workbook you are trying to reduce.
Save the files and then check the new file size by clicking the "Office Button" in Excel 2007.
Point to "Prepare" and then click on "Properties." In Excel 2003 or earlier, go to the "File" menu and select "Properties."
The file size will be listed on the "General" tab.



http://www.ozgrid.com/Excel/ExcelProblems.htm

Apr 22, 2013 | Microsoft Office Professional 2010

1 Answer

Reduce the size of excel file


Many businesses use Excel to track their data and expenses.
However, you can run into problems when files grow too big.
Try reducing the size of your Excel files in different ways to eliminate your storage problems.
Remove unnecessary graphics and fonts from the Excel file.
Simple report data doesn't need a lot of excess formatting to make it attractive.
If you need to keep different fonts in your file, reduce some of the font sizes you originally used.
Reduce the number of pivot tables you allow in your data analysis.
Run your pivot table wizard when dealing with involved calculations.
When given options to format the file, choose those that allow the data to refresh instead of adding a new table.


Input your data, close the file and save as an Excel (XLS format) file and as an HTML (XML format) file.
To do this, choose "XML Data" in the "Save as type" drop down box.
Change the name of your document as well, so you can tell the difference between the two files.

Open the XML file and save it back into the regular XLS file to create a smaller file than the original.
Again, rename this file, as well as changing its type. This act removes odd programming left from past calculations since the last "save."
Check into file compression software such as OzGrid.
These products exist because you cannot open a file once it gets too big.
Compress the XLS data by compelling the program to recalculate the cells used for your file.


Excel File Size Reduce Software 7.0
http://www.newfreedownloads.com/Business/Spreadsheets/Excel-File-Size-Reduce-Software.html

http://www.ozgrid.com/
or
Microsoft Excel files can contain thousands of cells filled with data.
When you combine this information with graphics, such as charts and graphs, as well as ever-expanding links to other worksheets, you can end up with an enormous file that takes up precious system space and slows Excel down.
While there are many software programs available that promise to shrink Excel files, there are many ways to reduce the bulk without downloading a new application.

1. Click on any cell in the Excel file you want to reduce.
Open the "Go To" dialog box in Excel 2007 by clicking the "Find" drop-down arrow on the Home tab of the ribbon and selecting "Go To."
In Excel 2003 or earlier, go to the "Edit" menu and select "Go To."
You can also use the keyboard shortcut "Ctrl+G" in any version of Excel.
2. Click the "Special" button on the "Go To" dialog box.
Select "Blanks" and click "OK." Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All." This will clear any blank cells to help reduce the file size.


3. Go to the very last cell containing data in the Excel file.
Select the entire row beneath this cell by clicking the number to the left of it.
Hold "Ctrl+Shift" and then press the down arrow key to select all of the cells beneath this point.

4. Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All."
Select the column to the right of the last cell. Hold "Ctrl+Shift" and then press the right arrow key. Again, select "Clear All."
5. Repeat Steps 1 through 5 for any other Excel files that are linked to the workbook you are trying to reduce.
Save the files and then check the new file size by clicking the "Office Button" in Excel 2007.
Point to "Prepare" and then click on "Properties." In Excel 2003 or earlier, go to the "File" menu and select "Properties."
The file size will be listed on the "General" tab.



http://www.ozgrid.com/Excel/ExcelProblems.htm

Apr 22, 2013 | Microsoft Office Business & Productivity...

3 Answers

How can I launch without recover.c


Look for the answer here: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/excel/653-i-get-a-message-that-the-file-is-damaged-or-corrupted

Or:
XLSX Repair Kit. The latest corrupt XLSX file repair software featuring a powerful data recovery core and a convenient step-by-step wizard for extra convenience.
For more information: http://www.xlsx.repair/

Dec 31, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

Same problem - excel files balllooning from 20Kb to 45Mb


This could happen if your workbook is being shared.
1. Make a backup copy of your workbook (Excel file).
2. Open it in Excel
3. Check under Tools > Share Workbook and see if the "Allow changes by more than one user..." option is selected. If so, try unchecking it and save the workbook
4. Check the file size under File > Properties > General tab


Another possibility is that there are a lot of unused cells with "invisible" formatting. To check that you can try pressing Ctrl+End and see where the end of your document is. If it is way beyond your current work area, select those extra columns and rows and go to Edit > Clear > All (Note: This will delete everything on those cells)


Aug 19, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

How to copy Excel worksheet in a word document?


go to Insert > File >select file and insert.
you have to select all documents when you when insert box opens.

Mar 15, 2009 | Microsoft Excel for PC

1 Answer

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.

Jan 14, 2009 | Microsoft Excel for PC

1 Answer

Invoice & Order Minimize Data Entry - Especially Name and Address


Do you have Microsoft Access? If so, you could use that to create a database and an invoice form. You could also use Access to "dump" the info into Excel to track and record.

Otherwise, try searching for "Import Data" in the Excel help. It would be very difficult to walk you through the whole process, but if you have specific questions about certain steps, that would be more manageable.

Jan 06, 2009 | Microsoft Excel for PC

1 Answer

Minimize Data Entry


I will suggest you to create small application in .net for ths which will add some value and process your data;If you want to use Excel only make a master sheet with details and use it in other excel sheets

Jan 02, 2009 | Microsoft Excel for PC

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

7,178 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

18330 Answers

Tony

Level 3 Expert

2598 Answers

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

Answer questions

Manuals & User Guides

Loading...