30,000Kb times two is 60,000Kb which is 60Mb

Depending upon your computer's resources, Excel may choke on that.


Gord Dibben MS Excel MVP

On Tue, 6 May 2008 12:52:06 -0700,
m wrote:

Dave,

When I try to open two workbooks, the fonts look all messed up, then I get
an out of memory message along with a printer setup error. I've tried this
on five different computers and I get the same results each time. I have
some VBA code in these workbooks, could it have anything to do with that? I
tried opening two 30,000 kb workbooks at the same time and that worked fine,
so to me it seems like something is wrong internally with the workbooks I'm
trying to open, but I'm not sure. Any ideas?

Thanks

Adam Bush

"Dave Peterson" wrote:

Why can't you open both workbooks in the same session of excel?

Open excel and then use File|Open (twice) to open both files????

wrote:

I can't open two workbooks at the same time in one version of Excel. To get
around this I opened Excel twice and opened one workbook in each version.
Now I realize that I can't copy formulas between the two versions, it only
gives me a static value when I try. Is there anyway to open these two
workbooks in the same version of Excel or copy formulas from one version of
Excel to the other? Both workbooks I'm using are basically the same, both
about 10,000 kb in size.

Thanks

Adam Bush

--

Dave Peterson