Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel File Growth Problem
Hi,
I am currently facing a strange problem updating an Excel File by a VB application. I have got around 1000 Rows of data, which I update programatically, on the basis of certain conditions. When updating, the file size grows very rapidly in MB's. I know this because our company has a policy of limited space on the shared area. One's you exceed 75%, it starts sending you emails. So everytime I run this program the file system starts growing. Very strangely, If I go see the file under question on Windows Explorer, it shows its size in KB's only. Could you please suggest a possible cause for this, an if known a resolution. Regards, Swapnil Jain |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel File Growth Problem
try
http://www.ozgrid.com/Excel/ExcelProblems.htm ben -- When you lose your mind, you free your life. "Swapnil" wrote: Hi, I am currently facing a strange problem updating an Excel File by a VB application. I have got around 1000 Rows of data, which I update programatically, on the basis of certain conditions. When updating, the file size grows very rapidly in MB's. I know this because our company has a policy of limited space on the shared area. One's you exceed 75%, it starts sending you emails. So everytime I run this program the file system starts growing. Very strangely, If I go see the file under question on Windows Explorer, it shows its size in KB's only. Could you please suggest a possible cause for this, an if known a resolution. Regards, Swapnil Jain |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
How do I project yearly growth rates in Excel? | Excel Discussion (Misc queries) | |||
Calculating Hypothetical Growth of $10,000 in Excel | Excel Discussion (Misc queries) | |||
Compounded Growth calculation Excel | Excel Discussion (Misc queries) | |||
How can I calculate trend growth rates in Excel? | Excel Discussion (Misc queries) |