Hi all

About 10,000 row and 30 column Xls file, the Excel can not open it......(full of formulas and macros)

i do not why........

could any one pls give some hints?

yours
hesham

hesham,

You could try setting your security level to Highest and then disabling the macros when you open the Workbook and/or set Recalculation to "Manual" rather than automatic.

CarlR
www.vba-programmer.com

Excel usually takes longer to open big files, specially, if you have formulas (i.e. vlookups) in one of your fields or columns and you save it in a share drive. If there is more than one user and somebody got impatient and cancelled the program while Excel was trying to open the file. It is possible the file has been damaged. That's probably why you cannot open it.

If you are the owner of this big files like this, always save it in your desktop aside from the share drive. It does'nt matter how big the file is. Excel can open faster and with ease. You can always update the file in the share drive.

Goodluck

I had a similar problem with a large workbook, one sheet contain 80,000 formulas. It took forever to load, save, recalculate, and it frequently crashed.

I replaced the 80,000 formulas with about 200 lines of code, it reduced the size of the workbook by about 80% and everything worked much better.

If you can put those formulas into the code with recalculated values being written back into the cells then you should find it works much better.