large files

[ahhhmed]

Hi,

I have a 16-mb excel 2007 file. I takes a lot of time to load. Can I make it load fast?

 

[Hui]

Ahhhmed

Try saving it as an Excel Binary file *.xlsb

 

[VictorGamboa]

To work with large files as well as working with binary files, should work with Excel2010 64-bit version, there is only a problem in migrating to this version, this version works with vba7 and is necessary to make several adjustments to the code base used. I'm having this problem!


But the 64bit version, play with a 16mb file.