Judging by your 2Gb comment, You must be running the 32bit version of excel. AS I understand it, 64 bit office contains both because the 64bit version is less compatible with previous 32bit addins and so the 32 bit is installed by default.
You might want to go back thru the install and try out the 64bit version of excel which does not have the 2GB addressing limitiation thou you may have to redo your spreadsheets(s)
Hi - If I am understanding your comments correctly than you are trying to say is that i am running a file which was originated on 32 bit of excel and currently being run on 64 bit of processor. If yes, then this is exactly what I am doing.
I will try to create a new file from scratch on 64 bit excel and hope it works fine.