An Excel file that we use is only about 2MB in size, but as soon as it is
opened, the memory usage of EXCEL.EXE jumps to over 1GB. We are running
Excel 2007 and this file is saved in the .xlsx format. Weird enough as using
that much memory is, when I save-as that file into Excel 2003 format, close
down Excel and open the new .xls file, EXCEL.EXE memory usage is only about
100MB. Why would a file saved in .xlsx format use 10 times more memory as a
file saved in .xls format? Both files are being opened through Excel 2007.

You liking applied formatting to a group of rows or columns which would have
formatted every row or column for that particular column or row. I know
thats a lot of verbiage to sort through but stick with me. Try highlighting
all of the empty cells to the right of your data, right click and click
"Delete". If prompted chose "Shift Cells Left". Then do the same thing for
the rows below your data, but this time chose "Shift Cells Up", if prompted
of course. The reason the 2007 files (.xlsx)would be so much larger than
2003 files (.xls) is because 2007 has over one million rows worth of cells
available is every sheet and 2003 offers just over 65K (2007 is actually
limitless but the 1 million and change figure comes with every sheet you
open, hold CTL + Down Arrow til you get to the bottom and you'll see what I'm
talking about). A similar relationship exists for columns between '03 and
'07. So after you have deleted the blank, but formatted, empty rows and
columns your file size should drastically decrease.

"PeteeWJ" wrote:

An Excel file that we use is only about 2MB in size, but as soon as it is
opened, the memory usage of EXCEL.EXE jumps to over 1GB. We are running
Excel 2007 and this file is saved in the .xlsx format. Weird enough as using
that much memory is, when I save-as that file into Excel 2003 format, close
down Excel and open the new .xls file, EXCEL.EXE memory usage is only about
100MB. Why would a file saved in .xlsx format use 10 times more memory as a
file saved in .xls format? Both files are being opened through Excel 2007.

After you save the file, of course,

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike" wrote in message
...
You liking applied formatting to a group of rows or columns which would
have
formatted every row or column for that particular column or row. I know
thats a lot of verbiage to sort through but stick with me. Try
highlighting
all of the empty cells to the right of your data, right click and click
"Delete". If prompted chose "Shift Cells Left". Then do the same thing
for
the rows below your data, but this time chose "Shift Cells Up", if
prompted
of course. The reason the 2007 files (.xlsx)would be so much larger than
2003 files (.xls) is because 2007 has over one million rows worth of cells
available is every sheet and 2003 offers just over 65K (2007 is actually
limitless but the 1 million and change figure comes with every sheet you
open, hold CTL + Down Arrow til you get to the bottom and you'll see what
I'm
talking about). A similar relationship exists for columns between '03 and
'07. So after you have deleted the blank, but formatted, empty rows and
columns your file size should drastically decrease.

"PeteeWJ" wrote:

An Excel file that we use is only about 2MB in size, but as soon as it is
opened, the memory usage of EXCEL.EXE jumps to over 1GB. We are running
Excel 2007 and this file is saved in the .xlsx format. Weird enough as
using
that much memory is, when I save-as that file into Excel 2003 format,
close
down Excel and open the new .xls file, EXCEL.EXE memory usage is only
about
100MB. Why would a file saved in .xlsx format use 10 times more memory
as a
file saved in .xls format? Both files are being opened through Excel
2007.

Extra empty rows or columns is not the problem. I can confirm there are not
extra columns or rows in the file. The file size is not the problem at 2MB.
The problem is massive amount of RAM Excel uses to have the file open. Any
idea why when the file is in Excel 2007 format it uses over 1GB of memory,
but when it is saved in Excel 2003 format it only uses 100MB of memory?

"Mike" wrote:

You liking applied formatting to a group of rows or columns which would have
formatted every row or column for that particular column or row. I know
thats a lot of verbiage to sort through but stick with me. Try highlighting
all of the empty cells to the right of your data, right click and click
"Delete". If prompted chose "Shift Cells Left". Then do the same thing for
the rows below your data, but this time chose "Shift Cells Up", if prompted
of course. The reason the 2007 files (.xlsx)would be so much larger than
2003 files (.xls) is because 2007 has over one million rows worth of cells
available is every sheet and 2003 offers just over 65K (2007 is actually
limitless but the 1 million and change figure comes with every sheet you
open, hold CTL + Down Arrow til you get to the bottom and you'll see what I'm
talking about). A similar relationship exists for columns between '03 and
'07. So after you have deleted the blank, but formatted, empty rows and
columns your file size should drastically decrease.

"PeteeWJ" wrote:

An Excel file that we use is only about 2MB in size, but as soon as it is
opened, the memory usage of EXCEL.EXE jumps to over 1GB. We are running
Excel 2007 and this file is saved in the .xlsx format. Weird enough as using
that much memory is, when I save-as that file into Excel 2003 format, close
down Excel and open the new .xls file, EXCEL.EXE memory usage is only about
100MB. Why would a file saved in .xlsx format use 10 times more memory as a
file saved in .xls format? Both files are being opened through Excel 2007.

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"PeteeWJ" wrote in message
...
Extra empty rows or columns is not the problem. I can confirm there are
not
extra columns or rows in the file. The file size is not the problem at
2MB.
The problem is massive amount of RAM Excel uses to have the file open.
Any
idea why when the file is in Excel 2007 format it uses over 1GB of memory,
but when it is saved in Excel 2003 format it only uses 100MB of memory?

"Mike" wrote:

You liking applied formatting to a group of rows or columns which would
have
formatted every row or column for that particular column or row. I know
thats a lot of verbiage to sort through but stick with me. Try
highlighting
all of the empty cells to the right of your data, right click and click
"Delete". If prompted chose "Shift Cells Left". Then do the same thing
for
the rows below your data, but this time chose "Shift Cells Up", if
prompted
of course. The reason the 2007 files (.xlsx)would be so much larger than
2003 files (.xls) is because 2007 has over one million rows worth of
cells
available is every sheet and 2003 offers just over 65K (2007 is actually
limitless but the 1 million and change figure comes with every sheet you
open, hold CTL + Down Arrow til you get to the bottom and you'll see what
I'm
talking about). A similar relationship exists for columns between '03
and
'07. So after you have deleted the blank, but formatted, empty rows and
columns your file size should drastically decrease.

"PeteeWJ" wrote:

An Excel file that we use is only about 2MB in size, but as soon as it
is
opened, the memory usage of EXCEL.EXE jumps to over 1GB. We are
running
Excel 2007 and this file is saved in the .xlsx format. Weird enough as
using
that much memory is, when I save-as that file into Excel 2003 format,
close
down Excel and open the new .xls file, EXCEL.EXE memory usage is only
about
100MB. Why would a file saved in .xlsx format use 10 times more memory
as a
file saved in .xls format? Both files are being opened through Excel
2007.