Hi All,
The attached file contains only one sheet with a few text in it. Still the file size is 3 MB+ I am not able to figure out why?
Can anybody please help me in figuring out why it is taking too much size?
I had to attach the zipped version as ExcelForum doesn't allow me to upload this much big file.
Thanks in Advance!
big_file.zip
Hi, Tejas,
delete the rows from Row78 on to the end as well as the columns from Z on - file size after that 21,2 KB.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hello HaHoBe,
Thanks for your answer.
Actually I have been able to reduce size by that. But I want to know the reason actually. This sheet is populated by a big VBA code I have written. So once I come to know about reason, I can make required changes in my code.
Hope you would help me further on this.
Thanks.
Hi, Tejas,
sorry but I canīt say anything about your code doing strange things to the file size as you have shown neither the code nor given details on the original file size. But I think itīs not that difficult to add two more lines of code to like
before saving.
Please Login or Register to view this content.
Ciao,
Holger
Thank you very much.
I have added that code. Problem solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks