Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why did my Excel file suddenly balloon in size?
I have an Excel file we use as an office schedule. It's essentially a
calendar with a tab for each month. When I updated the worksheet for 2006 the file size shot from 246K to 6.25M. Does anone have an idea why? Thanks!! |
#2
|
|||
|
|||
Is the file shared?
Joe "Dave" wrote in message ... I have an Excel file we use as an office schedule. It's essentially a calendar with a tab for each month. When I updated the worksheet for 2006 the file size shot from 246K to 6.25M. Does anone have an idea why? Thanks!! |
#3
|
|||
|
|||
No, I already checked that. The file is not shared, nor is there a history
tab. Dave "lunker55" wrote: Is the file shared? Joe "Dave" wrote in message ... I have an Excel file we use as an office schedule. It's essentially a calendar with a tab for each month. When I updated the worksheet for 2006 the file size shot from 246K to 6.25M. Does anone have an idea why? Thanks!! |
#4
|
|||
|
|||
All, I found the problem tab, deleted it and recreated it. Problem solved.
Thanks, Dave "Dave" wrote: No, I already checked that. The file is not shared, nor is there a history tab. Dave "lunker55" wrote: Is the file shared? Joe "Dave" wrote in message ... I have an Excel file we use as an office schedule. It's essentially a calendar with a tab for each month. When I updated the worksheet for 2006 the file size shot from 246K to 6.25M. Does anone have an idea why? Thanks!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why did my Excel file suddenly balloon in size?
Can you tell me how you found the problem tab? I have the same issue.
-- Thanks, Andy "Dave" wrote: All, I found the problem tab, deleted it and recreated it. Problem solved. Thanks, Dave "Dave" wrote: No, I already checked that. The file is not shared, nor is there a history tab. Dave "lunker55" wrote: Is the file shared? Joe "Dave" wrote in message ... I have an Excel file we use as an office schedule. It's essentially a calendar with a tab for each month. When I updated the worksheet for 2006 the file size shot from 246K to 6.25M. Does anone have an idea why? Thanks!! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why did my Excel file suddenly balloon in size?
Andy,
One of the solutions I was given was to find the last cell on the sheet and then delete all the data except what I wanted (something to do with erroneous data sometimes appearing later in a sheet). I used Ctrl+End to go to the last cell in the sheet and then deleted all rows and columns up to where my data ended. Then I would use Ctrl+End again to ensure that any erroneous data was gone. On the problem tab I tried this approach but no matter how many times I deleted rows and columns, Ctrl+End still took me well past the end of my data. I finally gave up and just deleted the sheet and the problem was solved. Hope this works for you, Dave "Andy Boruta" wrote: Can you tell me how you found the problem tab? I have the same issue. -- Thanks, Andy "Dave" wrote: All, I found the problem tab, deleted it and recreated it. Problem solved. Thanks, Dave "Dave" wrote: No, I already checked that. The file is not shared, nor is there a history tab. Dave "lunker55" wrote: Is the file shared? Joe "Dave" wrote in message ... I have an Excel file we use as an office schedule. It's essentially a calendar with a tab for each month. When I updated the worksheet for 2006 the file size shot from 246K to 6.25M. Does anone have an idea why? Thanks!! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why did my Excel file suddenly balloon in size?
Yeah...I ended up having to delete the sheet, as well. Thanks for the reply.
-- Thanks, Andy "Dave" wrote: Andy, One of the solutions I was given was to find the last cell on the sheet and then delete all the data except what I wanted (something to do with erroneous data sometimes appearing later in a sheet). I used Ctrl+End to go to the last cell in the sheet and then deleted all rows and columns up to where my data ended. Then I would use Ctrl+End again to ensure that any erroneous data was gone. On the problem tab I tried this approach but no matter how many times I deleted rows and columns, Ctrl+End still took me well past the end of my data. I finally gave up and just deleted the sheet and the problem was solved. Hope this works for you, Dave "Andy Boruta" wrote: Can you tell me how you found the problem tab? I have the same issue. -- Thanks, Andy "Dave" wrote: All, I found the problem tab, deleted it and recreated it. Problem solved. Thanks, Dave "Dave" wrote: No, I already checked that. The file is not shared, nor is there a history tab. Dave "lunker55" wrote: Is the file shared? Joe "Dave" wrote in message ... I have an Excel file we use as an office schedule. It's essentially a calendar with a tab for each month. When I updated the worksheet for 2006 the file size shot from 246K to 6.25M. Does anone have an idea why? Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Massive large size of Excel File after Updating | Excel Discussion (Misc queries) | |||
cannot open excel file, please help!!! | Excel Discussion (Misc queries) | |||
excel chart file size | Charts and Charting in Excel | |||
We have an excel file that is 52 megs in size and do not know why. | Excel Discussion (Misc queries) | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) |