| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
File Increase in size
Dear Sir,
I am working with an Excel file which has several pages, dynamic tables, macros, and build in formulas. My excel was 3 MB size las week. Suddenly, without any aparent reason the file shows 9 MB size. In the meanwhile I only added a small dynamic table which is no real explanation for the increase in size. I assume something inside got broken. Is there any maintenence program or procedure I could run over my file as to fix whatever went wrong? Thanks in advance, |
|
#3
|
|||
|
|||
|
File Increase in size
Hi Gary,
Nor did it work, nor does it explain why it trippled its own size. Any idea what may cause this? Any other idea how to repair it? Thanks "Gary L Brown" wrote: My suggestion would be to save your worksheets to a new workbook. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: Dear Sir, I am working with an Excel file which has several pages, dynamic tables, macros, and build in formulas. My excel was 3 MB size las week. Suddenly, without any aparent reason the file shows 9 MB size. In the meanwhile I only added a small dynamic table which is no real explanation for the increase in size. I assume something inside got broken. Is there any maintenence program or procedure I could run over my file as to fix whatever went wrong? Thanks in advance, |
|
#4
|
|||
|
|||
|
File Increase in size
What kind of a 'dynamic table' do you have? If it's a pivot table, it is
probably saving your information a second time. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: Hi Gary, Nor did it work, nor does it explain why it trippled its own size. Any idea what may cause this? Any other idea how to repair it? Thanks "Gary L Brown" wrote: My suggestion would be to save your worksheets to a new workbook. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: Dear Sir, I am working with an Excel file which has several pages, dynamic tables, macros, and build in formulas. My excel was 3 MB size las week. Suddenly, without any aparent reason the file shows 9 MB size. In the meanwhile I only added a small dynamic table which is no real explanation for the increase in size. I assume something inside got broken. Is there any maintenence program or procedure I could run over my file as to fix whatever went wrong? Thanks in advance, |
|
#5
|
|||
|
|||
|
File Increase in size
How can I do a correct diagnostic analisys as to be certain that is so? for I
see lots of chances they are. If the are the problem.... how can it be solved? "Gary L Brown" wrote: What kind of a 'dynamic table' do you have? If it's a pivot table, it is probably saving your information a second time. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: Hi Gary, Nor did it work, nor does it explain why it trippled its own size. Any idea what may cause this? Any other idea how to repair it? Thanks "Gary L Brown" wrote: My suggestion would be to save your worksheets to a new workbook. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: Dear Sir, I am working with an Excel file which has several pages, dynamic tables, macros, and build in formulas. My excel was 3 MB size las week. Suddenly, without any aparent reason the file shows 9 MB size. In the meanwhile I only added a small dynamic table which is no real explanation for the increase in size. I assume something inside got broken. Is there any maintenence program or procedure I could run over my file as to fix whatever went wrong? Thanks in advance, |
|
#6
|
|||
|
|||
|
File Increase in size
Right-click on the pivot table and select Table Options.
In the Data options section, if the 'Save data with table layout' is checked, you're saving your information twice (once in the original worksheet and once 'invisibly' in the worksheet the pivot table is on). I would suggest unchecking both the 'Save data with table layout' checkbox and the 'Enable drilldown' checkbox. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: How can I do a correct diagnostic analisys as to be certain that is so? for I see lots of chances they are. If the are the problem.... how can it be solved? "Gary L Brown" wrote: What kind of a 'dynamic table' do you have? If it's a pivot table, it is probably saving your information a second time. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: Hi Gary, Nor did it work, nor does it explain why it trippled its own size. Any idea what may cause this? Any other idea how to repair it? Thanks "Gary L Brown" wrote: My suggestion would be to save your worksheets to a new workbook. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: Dear Sir, I am working with an Excel file which has several pages, dynamic tables, macros, and build in formulas. My excel was 3 MB size las week. Suddenly, without any aparent reason the file shows 9 MB size. In the meanwhile I only added a small dynamic table which is no real explanation for the increase in size. I assume something inside got broken. Is there any maintenence program or procedure I could run over my file as to fix whatever went wrong? Thanks in advance, |
|
#7
|
|||
|
|||
|
File Increase in size
Done! Little improvement but some improvement.
What else can we do? "Gary L Brown" wrote: Right-click on the pivot table and select Table Options. In the Data options section, if the 'Save data with table layout' is checked, you're saving your information twice (once in the original worksheet and once 'invisibly' in the worksheet the pivot table is on). I would suggest unchecking both the 'Save data with table layout' checkbox and the 'Enable drilldown' checkbox. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: How can I do a correct diagnostic analisys as to be certain that is so? for I see lots of chances they are. If the are the problem.... how can it be solved? "Gary L Brown" wrote: What kind of a 'dynamic table' do you have? If it's a pivot table, it is probably saving your information a second time. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: Hi Gary, Nor did it work, nor does it explain why it trippled its own size. Any idea what may cause this? Any other idea how to repair it? Thanks "Gary L Brown" wrote: My suggestion would be to save your worksheets to a new workbook. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: Dear Sir, I am working with an Excel file which has several pages, dynamic tables, macros, and build in formulas. My excel was 3 MB size las week. Suddenly, without any aparent reason the file shows 9 MB size. In the meanwhile I only added a small dynamic table which is no real explanation for the increase in size. I assume something inside got broken. Is there any maintenence program or procedure I could run over my file as to fix whatever went wrong? Thanks in advance, |
|
#8
|
|||
|
|||
|
File Increase in size
One technique I use is, if I have a lot of vlookups, I'll make the column
with the vlookups values EXCEPT the first row so that I can easily copy down the formula if I need it again. I do the same with complicated formulas. I also usually highlight the 'formula' cell in LIGHT yellow (which doesn't usually show on a black and white printout) so I remember that it is a formula. Hope this helps and good luck, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: Done! Little improvement but some improvement. What else can we do? "Gary L Brown" wrote: Right-click on the pivot table and select Table Options. In the Data options section, if the 'Save data with table layout' is checked, you're saving your information twice (once in the original worksheet and once 'invisibly' in the worksheet the pivot table is on). I would suggest unchecking both the 'Save data with table layout' checkbox and the 'Enable drilldown' checkbox. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: How can I do a correct diagnostic analisys as to be certain that is so? for I see lots of chances they are. If the are the problem.... how can it be solved? "Gary L Brown" wrote: What kind of a 'dynamic table' do you have? If it's a pivot table, it is probably saving your information a second time. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: Hi Gary, Nor did it work, nor does it explain why it trippled its own size. Any idea what may cause this? Any other idea how to repair it? Thanks "Gary L Brown" wrote: My suggestion would be to save your worksheets to a new workbook. HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Martinj" wrote: Dear Sir, I am working with an Excel file which has several pages, dynamic tables, macros, and build in formulas. My excel was 3 MB size las week. Suddenly, without any aparent reason the file shows 9 MB size. In the meanwhile I only added a small dynamic table which is no real explanation for the increase in size. I assume something inside got broken. Is there any maintenence program or procedure I could run over my file as to fix whatever went wrong? Thanks in advance, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I deleted 99% of data from excel file. Folder Size remains unchang | Excel Discussion (Misc queries) | |||
| why does a workwook increase in size when emailing as attachment | Excel Discussion (Misc queries) | |||
| File size too big after converting Lotus 1-2-3 to Excel | Excel Discussion (Misc queries) | |||
| How do I reduce the size of an exel file? | Excel Discussion (Misc queries) | |||
| Deleted all images but file size still too big!! | Excel Discussion (Misc queries) | |||
Linear Mode
