Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"Bloated" Excel workbook
We have a 3 page Excel 2002 workbook. Four of us each copy it from a folder.
paste to the desktop, fill it in with the day's accounting figures and then email it. It ranges in size from 194 kb to 204 kb. One user oftentimes ends up with it being from 300 to 500 kb. What is happening? Thanks for any help with this! Shirley |
#2
|
|||
|
|||
Shirley
One reason why an Excel file gets "bloated" is that Excel thinks the file is bigger than it actually is. Do this. In each sheet in turn, do Ctrl - End. This will move the cell cursor to the cell that Excel thinks is the bottom - right cell of your data. You know what the actual bottom-right cell of your data is. If these two cells are far apart, then that's your problem. You say that one of the users has this problem. Do you mean that only this one user sees this "bloated" condition? If so, then the above does not relate to your problem. Post back with more info about the problem. HTH Otto "Shirley" wrote in message ... We have a 3 page Excel 2002 workbook. Four of us each copy it from a folder. paste to the desktop, fill it in with the day's accounting figures and then email it. It ranges in size from 194 kb to 204 kb. One user oftentimes ends up with it being from 300 to 500 kb. What is happening? Thanks for any help with this! Shirley |
#3
|
|||
|
|||
Thank you, Otto!
That is indeed the problem. Now, how do I fix them (they have to be kept) and how do I explain to her what she is doing so she won't do it anymore? Wow, that's asking a lot of you, isn't it? Thanks again, Shirley ~~~~~~~~~~~~~~~~~ "Otto Moehrbach" wrote: Shirley One reason why an Excel file gets "bloated" is that Excel thinks the file is bigger than it actually is. Do this. In each sheet in turn, do Ctrl - End. This will move the cell cursor to the cell that Excel thinks is the bottom - right cell of your data. You know what the actual bottom-right cell of your data is. If these two cells are far apart, then that's your problem. You say that one of the users has this problem. Do you mean that only this one user sees this "bloated" condition? If so, then the above does not relate to your problem. Post back with more info about the problem. HTH Otto "Shirley" wrote in message ... We have a 3 page Excel 2002 workbook. Four of us each copy it from a folder. paste to the desktop, fill it in with the day's accounting figures and then email it. It ranges in size from 194 kb to 204 kb. One user oftentimes ends up with it being from 300 to 500 kb. What is happening? Thanks for any help with this! Shirley |
#4
|
|||
|
|||
Shirley
You have to do this for each sheet of your file. Let's say that you have looked at the sheet and you have determined that your last cell is G50. Select row 51. You do this by clicking on the 51 in the column of row numbers at the left side of the screen. This selects the entire row. Now do Ctrl-Shift-Down Arrow (Hold down the Ctrl and Shift keys and hit the down arrow key). You just selected every row from row 51 to the last row, row 65,536. Now place the mouse pointer anywhere in the blue (selected) area, right-click, and click on Delete. This deletes all those rows, which are immediately replaced with new blank rows. Now select the H column by clicking on the H at the top of the column. Do Ctrl-Shift-Right Arrow. Right-click anywhere in the selected area and click on Delete. Now do the same thing in the rest of the sheets. Save the file. Close the file. Go into Explorer and see how big it is. Let me know if this works for you. If you have lots of sheets, there exists code to automate this process. Now open the file and do Ctrl-End on each of the sheets and see where it takes you. It would be prudent to try all this on a copy of your file first. HTH Otto "Shirley" wrote in message ... Thank you, Otto! That is indeed the problem. Now, how do I fix them (they have to be kept) and how do I explain to her what she is doing so she won't do it anymore? Wow, that's asking a lot of you, isn't it? Thanks again, Shirley ~~~~~~~~~~~~~~~~~ "Otto Moehrbach" wrote: Shirley One reason why an Excel file gets "bloated" is that Excel thinks the file is bigger than it actually is. Do this. In each sheet in turn, do Ctrl - End. This will move the cell cursor to the cell that Excel thinks is the bottom - right cell of your data. You know what the actual bottom-right cell of your data is. If these two cells are far apart, then that's your problem. You say that one of the users has this problem. Do you mean that only this one user sees this "bloated" condition? If so, then the above does not relate to your problem. Post back with more info about the problem. HTH Otto "Shirley" wrote in message ... We have a 3 page Excel 2002 workbook. Four of us each copy it from a folder. paste to the desktop, fill it in with the day's accounting figures and then email it. It ranges in size from 194 kb to 204 kb. One user oftentimes ends up with it being from 300 to 500 kb. What is happening? Thanks for any help with this! Shirley |
#5
|
|||
|
|||
This site may help in removing the unused rows:
http://www.contextures.com/xlfaqApp.html#Unused "Shirley" wrote: Thank you, Otto! That is indeed the problem. Now, how do I fix them (they have to be kept) and how do I explain to her what she is doing so she won't do it anymore? Wow, that's asking a lot of you, isn't it? Thanks again, Shirley ~~~~~~~~~~~~~~~~~ "Otto Moehrbach" wrote: Shirley One reason why an Excel file gets "bloated" is that Excel thinks the file is bigger than it actually is. Do this. In each sheet in turn, do Ctrl - End. This will move the cell cursor to the cell that Excel thinks is the bottom - right cell of your data. You know what the actual bottom-right cell of your data is. If these two cells are far apart, then that's your problem. You say that one of the users has this problem. Do you mean that only this one user sees this "bloated" condition? If so, then the above does not relate to your problem. Post back with more info about the problem. HTH Otto "Shirley" wrote in message ... We have a 3 page Excel 2002 workbook. Four of us each copy it from a folder. paste to the desktop, fill it in with the day's accounting figures and then email it. It ranges in size from 194 kb to 204 kb. One user oftentimes ends up with it being from 300 to 500 kb. What is happening? Thanks for any help with this! Shirley |
#6
|
|||
|
|||
Thank you both... That did it! I am amazed at the difference in size!
Shirley "Michael" wrote: This site may help in removing the unused rows: http://www.contextures.com/xlfaqApp.html#Unused "Shirley" wrote: Thank you, Otto! That is indeed the problem. Now, how do I fix them (they have to be kept) and how do I explain to her what she is doing so she won't do it anymore? Wow, that's asking a lot of you, isn't it? Thanks again, Shirley ~~~~~~~~~~~~~~~~~ "Otto Moehrbach" wrote: Shirley One reason why an Excel file gets "bloated" is that Excel thinks the file is bigger than it actually is. Do this. In each sheet in turn, do Ctrl - End. This will move the cell cursor to the cell that Excel thinks is the bottom - right cell of your data. You know what the actual bottom-right cell of your data is. If these two cells are far apart, then that's your problem. You say that one of the users has this problem. Do you mean that only this one user sees this "bloated" condition? If so, then the above does not relate to your problem. Post back with more info about the problem. HTH Otto "Shirley" wrote in message ... We have a 3 page Excel 2002 workbook. Four of us each copy it from a folder. paste to the desktop, fill it in with the day's accounting figures and then email it. It ranges in size from 194 kb to 204 kb. One user oftentimes ends up with it being from 300 to 500 kb. What is happening? Thanks for any help with this! Shirley |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Excel 2003 freeze when saving a workbook that has importe | Excel Worksheet Functions | |||
i can't open excel workbook if it has a chart in it! | Excel Discussion (Misc queries) | |||
link Access workbook to Excel workbook | Excel Discussion (Misc queries) | |||
how do i increase the sheets in a saved excel workbook? | Excel Worksheet Functions | |||
excel workbook | Excel Worksheet Functions |