Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel file grew to over 15 meg
I have an excel template that I am using to collect data. I have protected
the sheet to keep people from editing it. I have also used a lot of formating, and am using if statements. I have also been hiding rows to keep people from leaving the work area. and put my wor areas at the extreme edges of the worksheets. My file is made up of a dozen sheets. Until I started protecting the sheets, the file was less than 1 MG althought I have also added a couple of worksheets to the spreadsheet. When I zip the file, it compresses from 15meg to 1meg. What is causing the exponential growth in the spreadsheet and how can I reduce the size of the file? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel file grew to over 15 meg
It's probably that the last used cell that Excel thinks is actually the last
used cell is not in fact YOUR last used cell! On each sheet, hit Ctrl and End to find out which cell Excel thinks is the last used cell, then also on each sheet, find the actual used cell that you have with data in it. You will probably find large discepancies. From your actual last used cell, delete (not clear contents, DELETE) all the rows below it and all the columns to the right of it, save the file, re-open and see what size it is now, Regards, Alan. "Steve" wrote in message ... I have an excel template that I am using to collect data. I have protected the sheet to keep people from editing it. I have also used a lot of formating, and am using if statements. I have also been hiding rows to keep people from leaving the work area. and put my wor areas at the extreme edges of the worksheets. My file is made up of a dozen sheets. Until I started protecting the sheets, the file was less than 1 MG althought I have also added a couple of worksheets to the spreadsheet. When I zip the file, it compresses from 15meg to 1meg. What is causing the exponential growth in the spreadsheet and how can I reduce the size of the file? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel file grew to over 15 meg
That did not do it, (as the file continues to grow each time I save it).
Although you do appear to have at least part of my problem. At tleast for one sheet, when I hit CTRL-END it show up in R65536, however, I have deleted the rows and columns and saved and it still won't stop locking on that cell. I am taking everything out of the extremities (out of frustration) and it still continues to grow. "Alan" wrote: It's probably that the last used cell that Excel thinks is actually the last used cell is not in fact YOUR last used cell! On each sheet, hit Ctrl and End to find out which cell Excel thinks is the last used cell, then also on each sheet, find the actual used cell that you have with data in it. You will probably find large discepancies. From your actual last used cell, delete (not clear contents, DELETE) all the rows below it and all the columns to the right of it, save the file, re-open and see what size it is now, Regards, Alan. "Steve" wrote in message ... I have an excel template that I am using to collect data. I have protected the sheet to keep people from editing it. I have also used a lot of formating, and am using if statements. I have also been hiding rows to keep people from leaving the work area. and put my wor areas at the extreme edges of the worksheets. My file is made up of a dozen sheets. Until I started protecting the sheets, the file was less than 1 MG althought I have also added a couple of worksheets to the spreadsheet. When I zip the file, it compresses from 15meg to 1meg. What is causing the exponential growth in the spreadsheet and how can I reduce the size of the file? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel file grew to over 15 meg
Run this macro
http://www.contextures.com/xlfaqApp.html#Unused -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "Steve" wrote in message ... That did not do it, (as the file continues to grow each time I save it). Although you do appear to have at least part of my problem. At tleast for one sheet, when I hit CTRL-END it show up in R65536, however, I have deleted the rows and columns and saved and it still won't stop locking on that cell. I am taking everything out of the extremities (out of frustration) and it still continues to grow. "Alan" wrote: It's probably that the last used cell that Excel thinks is actually the last used cell is not in fact YOUR last used cell! On each sheet, hit Ctrl and End to find out which cell Excel thinks is the last used cell, then also on each sheet, find the actual used cell that you have with data in it. You will probably find large discepancies. From your actual last used cell, delete (not clear contents, DELETE) all the rows below it and all the columns to the right of it, save the file, re-open and see what size it is now, Regards, Alan. "Steve" wrote in message ... I have an excel template that I am using to collect data. I have protected the sheet to keep people from editing it. I have also used a lot of formating, and am using if statements. I have also been hiding rows to keep people from leaving the work area. and put my wor areas at the extreme edges of the worksheets. My file is made up of a dozen sheets. Until I started protecting the sheets, the file was less than 1 MG althought I have also added a couple of worksheets to the spreadsheet. When I zip the file, it compresses from 15meg to 1meg. What is causing the exponential growth in the spreadsheet and how can I reduce the size of the file? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel file grew to over 15 meg
Older versions of Excel require that you Save then Close and re-open to see the
changes. Also, your file cannot be aTemplate, because workbooks are created from Templates leaving the Template unchanged. Extension is XLT(template) or XLS(workbook)? Gord Dibben MS Excel MVP On Mon, 24 Jul 2006 15:57:01 -0700, Steve wrote: That did not do it, (as the file continues to grow each time I save it). Although you do appear to have at least part of my problem. At tleast for one sheet, when I hit CTRL-END it show up in R65536, however, I have deleted the rows and columns and saved and it still won't stop locking on that cell. I am taking everything out of the extremities (out of frustration) and it still continues to grow. "Alan" wrote: It's probably that the last used cell that Excel thinks is actually the last used cell is not in fact YOUR last used cell! On each sheet, hit Ctrl and End to find out which cell Excel thinks is the last used cell, then also on each sheet, find the actual used cell that you have with data in it. You will probably find large discepancies. From your actual last used cell, delete (not clear contents, DELETE) all the rows below it and all the columns to the right of it, save the file, re-open and see what size it is now, Regards, Alan. "Steve" wrote in message ... I have an excel template that I am using to collect data. I have protected the sheet to keep people from editing it. I have also used a lot of formating, and am using if statements. I have also been hiding rows to keep people from leaving the work area. and put my wor areas at the extreme edges of the worksheets. My file is made up of a dozen sheets. Until I started protecting the sheets, the file was less than 1 MG althought I have also added a couple of worksheets to the spreadsheet. When I zip the file, it compresses from 15meg to 1meg. What is causing the exponential growth in the spreadsheet and how can I reduce the size of the file? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel file grew to over 15 meg
I am running excel 2003
and you are correct, i am creating a Workbook (xls) And Alan appears to be right, but I am having to copy the sheets into a new sheet, and delete the old one to get rid of some of the excess cells. "Gord Dibben" wrote: Older versions of Excel require that you Save then Close and re-open to see the changes. Also, your file cannot be aTemplate, because workbooks are created from Templates leaving the Template unchanged. Extension is XLT(template) or XLS(workbook)? Gord Dibben MS Excel MVP On Mon, 24 Jul 2006 15:57:01 -0700, Steve wrote: That did not do it, (as the file continues to grow each time I save it). Although you do appear to have at least part of my problem. At tleast for one sheet, when I hit CTRL-END it show up in R65536, however, I have deleted the rows and columns and saved and it still won't stop locking on that cell. I am taking everything out of the extremities (out of frustration) and it still continues to grow. "Alan" wrote: It's probably that the last used cell that Excel thinks is actually the last used cell is not in fact YOUR last used cell! On each sheet, hit Ctrl and End to find out which cell Excel thinks is the last used cell, then also on each sheet, find the actual used cell that you have with data in it. You will probably find large discepancies. From your actual last used cell, delete (not clear contents, DELETE) all the rows below it and all the columns to the right of it, save the file, re-open and see what size it is now, Regards, Alan. "Steve" wrote in message ... I have an excel template that I am using to collect data. I have protected the sheet to keep people from editing it. I have also used a lot of formating, and am using if statements. I have also been hiding rows to keep people from leaving the work area. and put my wor areas at the extreme edges of the worksheets. My file is made up of a dozen sheets. Until I started protecting the sheets, the file was less than 1 MG althought I have also added a couple of worksheets to the spreadsheet. When I zip the file, it compresses from 15meg to 1meg. What is causing the exponential growth in the spreadsheet and how can I reduce the size of the file? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel file grew to over 15 meg
Thanks everyone. I don't know why, but I needed to copy the spreadsheets and
then delete the older ones. that said Alan was right and I am already at helf the size and shrinking with each worksheet. "Peo Sjoblom" wrote: Run this macro http://www.contextures.com/xlfaqApp.html#Unused -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "Steve" wrote in message ... That did not do it, (as the file continues to grow each time I save it). Although you do appear to have at least part of my problem. At tleast for one sheet, when I hit CTRL-END it show up in R65536, however, I have deleted the rows and columns and saved and it still won't stop locking on that cell. I am taking everything out of the extremities (out of frustration) and it still continues to grow. "Alan" wrote: It's probably that the last used cell that Excel thinks is actually the last used cell is not in fact YOUR last used cell! On each sheet, hit Ctrl and End to find out which cell Excel thinks is the last used cell, then also on each sheet, find the actual used cell that you have with data in it. You will probably find large discepancies. From your actual last used cell, delete (not clear contents, DELETE) all the rows below it and all the columns to the right of it, save the file, re-open and see what size it is now, Regards, Alan. "Steve" wrote in message ... I have an excel template that I am using to collect data. I have protected the sheet to keep people from editing it. I have also used a lot of formating, and am using if statements. I have also been hiding rows to keep people from leaving the work area. and put my wor areas at the extreme edges of the worksheets. My file is made up of a dozen sheets. Until I started protecting the sheets, the file was less than 1 MG althought I have also added a couple of worksheets to the spreadsheet. When I zip the file, it compresses from 15meg to 1meg. What is causing the exponential growth in the spreadsheet and how can I reduce the size of the file? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel file grew to over 15 meg
hi, not sure if it matters: have seen after deleting rows/columns, was
required to place cursor in cell A1 before saving, to reset the table. "Steve" wrote: Thanks everyone. I don't know why, but I needed to copy the spreadsheets and then delete the older ones. that said Alan was right and I am already at helf the size and shrinking with each worksheet. "Peo Sjoblom" wrote: Run this macro http://www.contextures.com/xlfaqApp.html#Unused -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "Steve" wrote in message ... That did not do it, (as the file continues to grow each time I save it). Although you do appear to have at least part of my problem. At tleast for one sheet, when I hit CTRL-END it show up in R65536, however, I have deleted the rows and columns and saved and it still won't stop locking on that cell. I am taking everything out of the extremities (out of frustration) and it still continues to grow. "Alan" wrote: It's probably that the last used cell that Excel thinks is actually the last used cell is not in fact YOUR last used cell! On each sheet, hit Ctrl and End to find out which cell Excel thinks is the last used cell, then also on each sheet, find the actual used cell that you have with data in it. You will probably find large discepancies. From your actual last used cell, delete (not clear contents, DELETE) all the rows below it and all the columns to the right of it, save the file, re-open and see what size it is now, Regards, Alan. "Steve" wrote in message ... I have an excel template that I am using to collect data. I have protected the sheet to keep people from editing it. I have also used a lot of formating, and am using if statements. I have also been hiding rows to keep people from leaving the work area. and put my wor areas at the extreme edges of the worksheets. My file is made up of a dozen sheets. Until I started protecting the sheets, the file was less than 1 MG althought I have also added a couple of worksheets to the spreadsheet. When I zip the file, it compresses from 15meg to 1meg. What is causing the exponential growth in the spreadsheet and how can I reduce the size of the file? |
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 | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Worksheet Functions | |||
Reflecting info between an excel file and a word one or two excel file. | Links and Linking in Excel | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) |