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
this is good effort by this web site to solve
problems.
this is good way to share our knowledge.
i think many of user are benifited by this
this is really appriciable.
×