If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HOW DO I REDUCE THE SIZE OF A EXCEL FILE (EX: 4MB - 1MB)
|
#2
|
|||
|
|||
HOW DO I REDUCE THE SIZE OF A EXCEL FILE (EX: 4MB - 1MB)
It would be good to have a bit more information like-
what prompts you see a need to reduce the size of the file? have you deleted all the data you don't want?-- Regards. Bill Ridgeway Computer Solutions "venkateswaran" wrote in message ... |
#3
|
|||
|
|||
HOW DO I REDUCE THE SIZE OF A EXCEL FILE (EX: 4MB - 1MB)
If you have a lot of formulae in the workbook then you can reduce the
size by fixing these to values - Copy, Edit, Paste Special, Values etc. Also, if you have a lot of named ranges which are no longer required, these can increase the size of the file. In addition, you could check on each worksheet what Excel thinks is the last used cell (CTRL-End), as you may have a lot of excess rows or columns and these can be deleted. Hope this helps. Pete |
#4
|
|||
|
|||
HOW DO I REDUCE THE SIZE OF A EXCEL FILE (EX: 4MB - 1MB)
It is big status report with 25 sheets in it, i cant delete any data.
The file size is around 4 mb is there any way to reduce the size, without zipping, removing formats, validations etc? "Bill Ridgeway" wrote: It would be good to have a bit more information like- what prompts you see a need to reduce the size of the file? have you deleted all the data you don't want?-- Regards. Bill Ridgeway Computer Solutions "venkateswaran" wrote in message ... |
#5
|
|||
|
|||
HOW DO I REDUCE THE SIZE OF A EXCEL FILE (EX: 4MB - 1MB)
Pete UK has suggested how you could reduce the size of the file and I
appreciate that with 25 worksheets doing this would be a bit of a job. However, you haven't said why you feel this needs to be done. Regards. Bill Ridgeway Computer Solutions "venkateswaran" wrote in message ... It is big status report with 25 sheets in it, i cant delete any data. The file size is around 4 mb is there any way to reduce the size, without zipping, removing formats, validations etc? "Bill Ridgeway" wrote: It would be good to have a bit more information like- what prompts you see a need to reduce the size of the file? have you deleted all the data you don't want?-- Regards. Bill Ridgeway Computer Solutions "venkateswaran" wrote in message ... |
#6
|
|||
|
|||
HOW DO I REDUCE THE SIZE OF A EXCEL FILE (EX: 4MB - 1MB)
Hello:
Reminds of the person who asks can I lose weight? (and not reduce what I eat and without excerising more) NO. Pieter Vandenberg : It is big status report with 25 sheets in it, i cant delete any data. : The file size is around 4 mb : is there any way to reduce the size, without zipping, removing formats, : validations etc? |
#7
|
|||
|
|||
HOW DO I REDUCE THE SIZE OF A EXCEL FILE (EX: 4MB - 1MB)
A slightly off the wall suggestion--make sure you are saving it as a "pure"
excel file type. By that I mean saving a file as "Microsoft Excel Workbook (*.xls)". If you save with a type like "Microsoft Excel 97-2002 & 5.0/95 Workbook (*.xls)" you can easily double the file size. I just opened up a 19MB file I have and did a "save as" to the combined file type in the above sentence--it nearly doubled in size... You can easily remove "excess" formatting with a "clear excess formats" excel addin--I think I found in on the Microsoft support website--don't remember... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
If I buy Microsoft office, will I be able to open my old files on | laurelek | General Discussions | 3 | February 13th, 2009 02:56 PM |
how to reduce file size of excel workbooks | Teri_2226 | General Discussion | 1 | October 24th, 2005 04:31 PM |
File size too big after converting Lotus 1-2-3 to Excel | Learner | General Discussion | 3 | June 10th, 2005 08:27 PM |
Multi-User vs Client/Server | GeorgieGirl | General Discussion | 3 | June 8th, 2005 11:42 PM |
Product Key for Office XP | P.G.Indiana | Setup, Installing & Configuration | 1 | June 7th, 2004 03:22 AM |