Large Excel file size caused by a bug ? I really tried everything

Hi,
I have an Excel file of 1 worksheet, containing data in about 20 rows by 20
columns, which is 310 kB ! I noticed copying the range of cells A3:E7 and
pasting it doubles the file size, but I cannot find anything wrong in those
cells. I tried the following:
1) If I copy all worksheet and paste it in a new worksheet file, the new
file size is the same, > 300kB
2) If I copy and paste all the data column by column, the new file size is
16 kB !
3) If I copy all worksheet and paste values only, the new file size is 14 kB
4) If I delete all the data and the cell formats in the original worksheet,
I still get a large size of > 300 kB !
This is weird. I have nothing in the worksheet, no hidden worksheet, and I
really deleted the rows and columns by selecting them and pressing DELETE.
When I press CTRL-END, the cursor stays at cell A1.

Please help me understand this !

Thanks,
Anik

Did you SAVE the workbook after trying these things?

--
Don Guillett
SalesAid Software
[email protected]
"Anik" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> I have an Excel file of 1 worksheet, containing data in about 20 rows by
20
> columns, which is 310 kB ! I noticed copying the range of cells A3:E7 and
> pasting it doubles the file size, but I cannot find anything wrong in
those
> cells. I tried the following:
> 1) If I copy all worksheet and paste it in a new worksheet file, the new
> file size is the same, > 300kB
> 2) If I copy and paste all the data column by column, the new file size is
> 16 kB !
> 3) If I copy all worksheet and paste values only, the new file size is 14
kB
> 4) If I delete all the data and the cell formats in the original
worksheet,
> I still get a large size of > 300 kB !
> This is weird. I have nothing in the worksheet, no hidden worksheet, and I
> really deleted the rows and columns by selecting them and pressing DELETE.
> When I press CTRL-END, the cursor stays at cell A1.
>
> Please help me understand this !
>
> Thanks,
> Anik

Yes I did save the files under different names, I even closed and opened
Excel. You can see that file size changes when I copy-paste the cells
individually or with values only. I can send you the file if you wish, you'll
see it is emply and still < 300kB

"Don Guillett" wrote:

> Did you SAVE the workbook after trying these things?
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Anik" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> > I have an Excel file of 1 worksheet, containing data in about 20 rows by
> 20
> > columns, which is 310 kB ! I noticed copying the range of cells A3:E7 and
> > pasting it doubles the file size, but I cannot find anything wrong in
> those
> > cells. I tried the following:
> > 1) If I copy all worksheet and paste it in a new worksheet file, the new
> > file size is the same, > 300kB
> > 2) If I copy and paste all the data column by column, the new file size is
> > 16 kB !
> > 3) If I copy all worksheet and paste values only, the new file size is 14
> kB
> > 4) If I delete all the data and the cell formats in the original
> worksheet,
> > I still get a large size of > 300 kB !
> > This is weird. I have nothing in the worksheet, no hidden worksheet, and I
> > really deleted the rows and columns by selecting them and pressing DELETE.
> > When I press CTRL-END, the cursor stays at cell A1.
> >
> > Please help me understand this !
> >
> > Thanks,
> > Anik
>
>
>

Please don't. I am on dialup

--
Don Guillett
SalesAid Software
[email protected]
"Anik" <[email protected]> wrote in message
news:[email protected]...
> Yes I did save the files under different names, I even closed and opened
> Excel. You can see that file size changes when I copy-paste the cells
> individually or with values only. I can send you the file if you wish,
you'll
> see it is emply and still < 300kB
>
> "Don Guillett" wrote:
>
> > Did you SAVE the workbook after trying these things?
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "Anik" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hi,
> > > I have an Excel file of 1 worksheet, containing data in about 20 rows
by
> > 20
> > > columns, which is 310 kB ! I noticed copying the range of cells A3:E7
and
> > > pasting it doubles the file size, but I cannot find anything wrong in
> > those
> > > cells. I tried the following:
> > > 1) If I copy all worksheet and paste it in a new worksheet file, the
new
> > > file size is the same, > 300kB
> > > 2) If I copy and paste all the data column by column, the new file
size is
> > > 16 kB !
> > > 3) If I copy all worksheet and paste values only, the new file size is
14
> > kB
> > > 4) If I delete all the data and the cell formats in the original
> > worksheet,
> > > I still get a large size of > 300 kB !
> > > This is weird. I have nothing in the worksheet, no hidden worksheet,
and I
> > > really deleted the rows and columns by selecting them and pressing
DELETE.
> > > When I press CTRL-END, the cursor stays at cell A1.
> > >
> > > Please help me understand this !
> > >
> > > Thanks,
> > > Anik
> >
> >
> >

Please can anyone help me on this ?

"Don Guillett" wrote:

> Please don't. I am on dialup
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Anik" <[email protected]> wrote in message
> news:[email protected]...
> > Yes I did save the files under different names, I even closed and opened
> > Excel. You can see that file size changes when I copy-paste the cells
> > individually or with values only. I can send you the file if you wish,
> you'll
> > see it is emply and still < 300kB
> >
> > "Don Guillett" wrote:
> >
> > > Did you SAVE the workbook after trying these things?
> > >
> > > --
> > > Don Guillett
> > > SalesAid Software
> > > [email protected]
> > > "Anik" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > Hi,
> > > > I have an Excel file of 1 worksheet, containing data in about 20 rows
> by
> > > 20
> > > > columns, which is 310 kB ! I noticed copying the range of cells A3:E7
> and
> > > > pasting it doubles the file size, but I cannot find anything wrong in
> > > those
> > > > cells. I tried the following:
> > > > 1) If I copy all worksheet and paste it in a new worksheet file, the
> new
> > > > file size is the same, > 300kB
> > > > 2) If I copy and paste all the data column by column, the new file
> size is
> > > > 16 kB !
> > > > 3) If I copy all worksheet and paste values only, the new file size is
> 14
> > > kB
> > > > 4) If I delete all the data and the cell formats in the original
> > > worksheet,
> > > > I still get a large size of > 300 kB !
> > > > This is weird. I have nothing in the worksheet, no hidden worksheet,
> and I
> > > > really deleted the rows and columns by selecting them and pressing
> DELETE.
> > > > When I press CTRL-END, the cursor stays at cell A1.
> > > >
> > > > Please help me understand this !
> > > >
> > > > Thanks,
> > > > Anik
> > >
> > >
> > >
>
>
>

Just to let you guys know that I found my problem.
I had several small graphics hidden in a cell that had been minimized there
by someone else. By pressing F5, then "Special", then "Objects", then OK, I
could find my graphics and delete them.
I hope this will help others.

"Anik" wrote:

> Hi,
> I have an Excel file of 1 worksheet, containing data in about 20 rows by 20
> columns, which is 310 kB ! I noticed copying the range of cells A3:E7 and
> pasting it doubles the file size, but I cannot find anything wrong in those
> cells. I tried the following:
> 1) If I copy all worksheet and paste it in a new worksheet file, the new
> file size is the same, > 300kB
> 2) If I copy and paste all the data column by column, the new file size is
> 16 kB !
> 3) If I copy all worksheet and paste values only, the new file size is 14 kB
> 4) If I delete all the data and the cell formats in the original worksheet,
> I still get a large size of > 300 kB !
> This is weird. I have nothing in the worksheet, no hidden worksheet, and I
> really deleted the rows and columns by selecting them and pressing DELETE.
> When I press CTRL-END, the cursor stays at cell A1.
>
> Please help me understand this !
>
> Thanks,
> Anik