Hi,
I am analyzing a large amount of data for a project, and so I am attempting to use the Database functions within Excel to speed up the analysis. However, after I set up the first set of DSUM equations, my file size jumped from ~50k to ~40MB! Any help would be much appreciated.
Here are the details:
- I am using Excel 2007, and Windows XP Professional. My files are .xlsx
- My data is contained in 8 source files, each of which has ~500,000 rows and 17 columns, and consequently each source file is ~40MB.
- As I have multiple source files, I have tried to create one summary / calculation file which referenced the source files. This file pulls data from the source files using DSUM equations.
I was able to set up the first DSUM calculation correctly, and it pulled the correct value. However, when I saved the calculation file, its size jumped from ~50k to ~40MB. I have tried the usual tricks of deleting all columns and rows past the active part of the worksheet, checking for blank cells and clearing all, closing and re-opening the file, etc., but the size of the file remains unchanged.
I am wondering if there is something about using DSUM to reference the source file (an external file) that causes Excel to store the contents of the source file in the calculation file, thus causing the massive increase in file size? Or is there another reason for the increase?
Any help would be greatly appreciated.
PFVP
I am analyzing a large amount of data for a project, and so I am attempting to use the Database functions within Excel to speed up the analysis. However, after I set up the first set of DSUM equations, my file size jumped from ~50k to ~40MB! Any help would be much appreciated.
Here are the details:
- I am using Excel 2007, and Windows XP Professional. My files are .xlsx
- My data is contained in 8 source files, each of which has ~500,000 rows and 17 columns, and consequently each source file is ~40MB.
- As I have multiple source files, I have tried to create one summary / calculation file which referenced the source files. This file pulls data from the source files using DSUM equations.
I was able to set up the first DSUM calculation correctly, and it pulled the correct value. However, when I saved the calculation file, its size jumped from ~50k to ~40MB. I have tried the usual tricks of deleting all columns and rows past the active part of the worksheet, checking for blank cells and clearing all, closing and re-opening the file, etc., but the size of the file remains unchanged.
I am wondering if there is something about using DSUM to reference the source file (an external file) that causes Excel to store the contents of the source file in the calculation file, thus causing the massive increase in file size? Or is there another reason for the increase?
Any help would be greatly appreciated.
PFVP
