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

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

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

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

And in the odd chance that it's the printer that's causing the trouble, you may
want to open excel, then change your default printer to something else, then
open your two files.



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


--

Dave Peterson

Gord,

What I was saying was I CAN open two 30mb workbooks at the same time with no
problem. When I open the two workbooks in question, which are only 20 mb
combined, I get the errors and Excel shuts down.

Adam Bush

"Gord Dibben" wrote:

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

Upon a careful re-read of your original post I see that you said you tried to
open two 30,000Kb files and "it worked fine".

My mistake. Ignore my blathering on.


Gord

On Wed, 7 May 2008 08:58:01 -0700,
m wrote:

Gord,

What I was saying was I CAN open two 30mb workbooks at the same time with no
problem. When I open the two workbooks in question, which are only 20 mb
combined, I get the errors and Excel shuts down.

Adam Bush

"Gord Dibben" wrote:

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