Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
No reason for Large excel file-don't know why
Im seeing various posts on this subject but the suggestions already given
dont answer what is happening. Thought Id throw it out for the gurus to see if they have an answer. I have a file or rather a sequence of activities that leads to an excessively large file. Im not looking for the quick fix. Im trying to understand the why so that Im not blindly creating the same issues to a smaller degree in my processes. I have a series of workbooks that are task specific. The formulas, links and data size have lead me to task specific books to keep calculation wait times down. Ive designed them so that a copy and paste from one workbook (essentially its output) becomes an input for another book. I could link them but I dont like twiddling my thumbs ! I have the following happening. If I create a copy of a worksheet in say Book A, place it in a new book, paste values, remove all names, delete all columns and rows not needed to clear out old stuff, I get an acceptable file of 282kb. If I take the same sheet, paste it into my next workbook, remove all linked formulas and save it. Then if I create a copy of this same worksheet, place it in a new book, paste values, remove all range names, delete all columns and rows not needed to clear out old stuff. Also making sure there are no live links. I get a file of 1.66MB! I have then taken that file and deleted all columns except A, then deleted A, Removed all formats, pasted all cell values, cleared all cell contents, made sure their were no range names, or macros and saved the file again. In my mind it should be a new worksheet after that but the file is still 1.46MB ! If I insert a new sheet, delete the one I have been working on and save, Im down to 13KB. That to me says the sheet is the problemo ! My question is what can be hanging on that keeps this sheet so large? In each book the sheet was linked to by various formulas from other sheets. In many cases the sheet had links to other sheets and or books. I'm thinking that those linkages though supposedly severed by pasting values still exist within the sheet. Excel says there are no links but its all I can come up with! Can't prove it but its my suspicion. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
No reason for Large excel file-don't know why
I didn't read your question too closely but I think you are describing
problems with your used range. Sometimes Excel remembers cells that are now blank, which bloats your file. Copy and paste sometimes causes it. Pivot tables also tend to create the problem (among other things). Here is a link to clean up the used range... http://www.contextures.com/xlfaqApp.html#Unused -- HTH... Jim Thomlinson "onewildchild" wrote: Im seeing various posts on this subject but the suggestions already given dont answer what is happening. Thought Id throw it out for the gurus to see if they have an answer. I have a file or rather a sequence of activities that leads to an excessively large file. Im not looking for the quick fix. Im trying to understand the why so that Im not blindly creating the same issues to a smaller degree in my processes. I have a series of workbooks that are task specific. The formulas, links and data size have lead me to task specific books to keep calculation wait times down. Ive designed them so that a copy and paste from one workbook (essentially its output) becomes an input for another book. I could link them but I dont like twiddling my thumbs ! I have the following happening. If I create a copy of a worksheet in say Book A, place it in a new book, paste values, remove all names, delete all columns and rows not needed to clear out old stuff, I get an acceptable file of 282kb. If I take the same sheet, paste it into my next workbook, remove all linked formulas and save it. Then if I create a copy of this same worksheet, place it in a new book, paste values, remove all range names, delete all columns and rows not needed to clear out old stuff. Also making sure there are no live links. I get a file of 1.66MB! I have then taken that file and deleted all columns except A, then deleted A, Removed all formats, pasted all cell values, cleared all cell contents, made sure their were no range names, or macros and saved the file again. In my mind it should be a new worksheet after that but the file is still 1.46MB ! If I insert a new sheet, delete the one I have been working on and save, Im down to 13KB. That to me says the sheet is the problemo ! My question is what can be hanging on that keeps this sheet so large? In each book the sheet was linked to by various formulas from other sheets. In many cases the sheet had links to other sheets and or books. I'm thinking that those linkages though supposedly severed by pasting values still exist within the sheet. Excel says there are no links but its all I can come up with! Can't prove it but its my suspicion. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
No reason for Large excel file-don't know why
Thanks Jim but I have already tried that and it doesn't remove the issue.
"Jim Thomlinson" wrote: I didn't read your question too closely but I think you are describing problems with your used range. Sometimes Excel remembers cells that are now blank, which bloats your file. Copy and paste sometimes causes it. Pivot tables also tend to create the problem (among other things). Here is a link to clean up the used range... http://www.contextures.com/xlfaqApp.html#Unused -- HTH... Jim Thomlinson "onewildchild" wrote: Im seeing various posts on this subject but the suggestions already given dont answer what is happening. Thought Id throw it out for the gurus to see if they have an answer. I have a file or rather a sequence of activities that leads to an excessively large file. Im not looking for the quick fix. Im trying to understand the why so that Im not blindly creating the same issues to a smaller degree in my processes. I have a series of workbooks that are task specific. The formulas, links and data size have lead me to task specific books to keep calculation wait times down. Ive designed them so that a copy and paste from one workbook (essentially its output) becomes an input for another book. I could link them but I dont like twiddling my thumbs ! I have the following happening. If I create a copy of a worksheet in say Book A, place it in a new book, paste values, remove all names, delete all columns and rows not needed to clear out old stuff, I get an acceptable file of 282kb. If I take the same sheet, paste it into my next workbook, remove all linked formulas and save it. Then if I create a copy of this same worksheet, place it in a new book, paste values, remove all range names, delete all columns and rows not needed to clear out old stuff. Also making sure there are no live links. I get a file of 1.66MB! I have then taken that file and deleted all columns except A, then deleted A, Removed all formats, pasted all cell values, cleared all cell contents, made sure their were no range names, or macros and saved the file again. In my mind it should be a new worksheet after that but the file is still 1.46MB ! If I insert a new sheet, delete the one I have been working on and save, Im down to 13KB. That to me says the sheet is the problemo ! My question is what can be hanging on that keeps this sheet so large? In each book the sheet was linked to by various formulas from other sheets. In many cases the sheet had links to other sheets and or books. I'm thinking that those linkages though supposedly severed by pasting values still exist within the sheet. Excel says there are no links but its all I can come up with! Can't prove it but its my suspicion. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
No reason for Large excel file-don't know why
Only thought that comes to my mind... When you delete all columns, are you
then going to cell A1, then saving? Also, just to be sure, when deleting coluns, are you deleting eith Edit/Delete or right/click delete? If just hitting the delete key or clear contents, it will retain the same size. Not sure of any other ideas... "onewildchild" wrote: Thanks Jim but I have already tried that and it doesn't remove the issue. "Jim Thomlinson" wrote: I didn't read your question too closely but I think you are describing problems with your used range. Sometimes Excel remembers cells that are now blank, which bloats your file. Copy and paste sometimes causes it. Pivot tables also tend to create the problem (among other things). Here is a link to clean up the used range... http://www.contextures.com/xlfaqApp.html#Unused -- HTH... Jim Thomlinson "onewildchild" wrote: Im seeing various posts on this subject but the suggestions already given dont answer what is happening. Thought Id throw it out for the gurus to see if they have an answer. I have a file or rather a sequence of activities that leads to an excessively large file. Im not looking for the quick fix. Im trying to understand the why so that Im not blindly creating the same issues to a smaller degree in my processes. I have a series of workbooks that are task specific. The formulas, links and data size have lead me to task specific books to keep calculation wait times down. Ive designed them so that a copy and paste from one workbook (essentially its output) becomes an input for another book. I could link them but I dont like twiddling my thumbs ! I have the following happening. If I create a copy of a worksheet in say Book A, place it in a new book, paste values, remove all names, delete all columns and rows not needed to clear out old stuff, I get an acceptable file of 282kb. If I take the same sheet, paste it into my next workbook, remove all linked formulas and save it. Then if I create a copy of this same worksheet, place it in a new book, paste values, remove all range names, delete all columns and rows not needed to clear out old stuff. Also making sure there are no live links. I get a file of 1.66MB! I have then taken that file and deleted all columns except A, then deleted A, Removed all formats, pasted all cell values, cleared all cell contents, made sure their were no range names, or macros and saved the file again. In my mind it should be a new worksheet after that but the file is still 1.46MB ! If I insert a new sheet, delete the one I have been working on and save, Im down to 13KB. That to me says the sheet is the problemo ! My question is what can be hanging on that keeps this sheet so large? In each book the sheet was linked to by various formulas from other sheets. In many cases the sheet had links to other sheets and or books. I'm thinking that those linkages though supposedly severed by pasting values still exist within the sheet. Excel says there are no links but its all I can come up with! Can't prove it but its my suspicion. Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
No reason for Large excel file-don't know why
Yes - on returning to cell A1
Yes - on using the right click delete. I'm left with a 1.41MB file that contains only the sheet I've been discussing "Sean Timmons" wrote: Only thought that comes to my mind... When you delete all columns, are you then going to cell A1, then saving? Also, just to be sure, when deleting coluns, are you deleting eith Edit/Delete or right/click delete? If just hitting the delete key or clear contents, it will retain the same size. Not sure of any other ideas... "onewildchild" wrote: Thanks Jim but I have already tried that and it doesn't remove the issue. "Jim Thomlinson" wrote: I didn't read your question too closely but I think you are describing problems with your used range. Sometimes Excel remembers cells that are now blank, which bloats your file. Copy and paste sometimes causes it. Pivot tables also tend to create the problem (among other things). Here is a link to clean up the used range... http://www.contextures.com/xlfaqApp.html#Unused -- HTH... Jim Thomlinson "onewildchild" wrote: Im seeing various posts on this subject but the suggestions already given dont answer what is happening. Thought Id throw it out for the gurus to see if they have an answer. I have a file or rather a sequence of activities that leads to an excessively large file. Im not looking for the quick fix. Im trying to understand the why so that Im not blindly creating the same issues to a smaller degree in my processes. I have a series of workbooks that are task specific. The formulas, links and data size have lead me to task specific books to keep calculation wait times down. Ive designed them so that a copy and paste from one workbook (essentially its output) becomes an input for another book. I could link them but I dont like twiddling my thumbs ! I have the following happening. If I create a copy of a worksheet in say Book A, place it in a new book, paste values, remove all names, delete all columns and rows not needed to clear out old stuff, I get an acceptable file of 282kb. If I take the same sheet, paste it into my next workbook, remove all linked formulas and save it. Then if I create a copy of this same worksheet, place it in a new book, paste values, remove all range names, delete all columns and rows not needed to clear out old stuff. Also making sure there are no live links. I get a file of 1.66MB! I have then taken that file and deleted all columns except A, then deleted A, Removed all formats, pasted all cell values, cleared all cell contents, made sure their were no range names, or macros and saved the file again. In my mind it should be a new worksheet after that but the file is still 1.46MB ! If I insert a new sheet, delete the one I have been working on and save, Im down to 13KB. That to me says the sheet is the problemo ! My question is what can be hanging on that keeps this sheet so large? In each book the sheet was linked to by various formulas from other sheets. In many cases the sheet had links to other sheets and or books. I'm thinking that those linkages though supposedly severed by pasting values still exist within the sheet. Excel says there are no links but its all I can come up with! Can't prove it but its my suspicion. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Need to Query Excel File Opened by Another User | Excel Discussion (Misc queries) | |||
Retaining formats | Excel Discussion (Misc queries) | |||
Excel file automatically opens | Excel Discussion (Misc queries) | |||
How do I unlock FILE access? | Excel Discussion (Misc queries) |