Calculating values...
 

Hi. I have a template that takes cell contents from another workbook and
then changes the formulas to get those contents into values on a save. I
then have formulas inside the spreadsheet that need to be performed based on
what is put in the cells it populates from the other workbook. If I just say
=sum(H26/G26), it doesn't perform the formula when H26 and G26 are populated.


Any ideas?

Cathy

Calculating values...
 

Hi Cathy,

A bit more info might do:

What exactly are your formulas? Are any macros involved?
What do you mean by "then changes the formulas"? How do you do that?
Do you see results in the cells which "doesn't perform the formula" or do
you see the formula?
etc....

--
Kind regards,

Niek Otten

"Cathy W" wrote in message
...
Hi. I have a template that takes cell contents from another workbook and
then changes the formulas to get those contents into values on a save. I
then have formulas inside the spreadsheet that need to be performed based
on
what is put in the cells it populates from the other workbook. If I just
say
=sum(H26/G26), it doesn't perform the formula when H26 and G26 are
populated.


Any ideas?

Cathy

Calculating values...
 

Thanks for the reply Niek..I am doing everything I need to do through code in
the background. The user double clicks the template and it opens, then an
open dialog appears and asks them to choose the file in which to get the
values from. This filename is then stored in cell A1. Then, this populates
the formulas in the spreadsheet with the values from certain cells. The
forumla to get the values from the other workbook is as
follows:=INDIRECT("'[" & A1& "]dos2'!K9"). Then in the same step it takes
all the values that were copied from the other workbook and pastes special -
values so that when the user saves the file they can send it having no like
to any other file. After the paste special, the save as dialog appears for
them to save the file. The loop hole is that I have forumlas that are based
on the values that are bought in by the formulas above. For example,

B6 contains =INDIRECT("'[" & A1& "]dos2'!K9")
B7 contains =INDIRECT("'[" & A1& "]dos2'!K10")
and B8 needs to be =sum(b6/b7)

I think I need to tell it to perform these forumlas before pasting special,
but I don't know how. If you need me to paste the code I have that's no
problem.

Thanks for your help in advance,
Cathy

"Niek Otten" wrote:

Hi Cathy,

A bit more info might do:

What exactly are your formulas? Are any macros involved?
What do you mean by "then changes the formulas"? How do you do that?
Do you see results in the cells which "doesn't perform the formula" or do
you see the formula?
etc....

--
Kind regards,

Niek Otten

"Cathy W" wrote in message
...
Hi. I have a template that takes cell contents from another workbook and
then changes the formulas to get those contents into values on a save. I
then have formulas inside the spreadsheet that need to be performed based
on
what is put in the cells it populates from the other workbook. If I just
say
=sum(H26/G26), it doesn't perform the formula when H26 and G26 are
populated.


Any ideas?

Cathy

Calculating values...
 

Does "Application.Calculate" help?

--
Kind regards,

Niek Otten

"Cathy W" wrote in message
...
Thanks for the reply Niek..I am doing everything I need to do through code
in
the background. The user double clicks the template and it opens, then an
open dialog appears and asks them to choose the file in which to get the
values from. This filename is then stored in cell A1. Then, this
populates
the formulas in the spreadsheet with the values from certain cells. The
forumla to get the values from the other workbook is as
follows:=INDIRECT("'[" & A1& "]dos2'!K9"). Then in the same step it takes
all the values that were copied from the other workbook and pastes
special -
values so that when the user saves the file they can send it having no
like
to any other file. After the paste special, the save as dialog appears
for
them to save the file. The loop hole is that I have forumlas that are
based
on the values that are bought in by the formulas above. For example,

B6 contains =INDIRECT("'[" & A1& "]dos2'!K9")
B7 contains =INDIRECT("'[" & A1& "]dos2'!K10")
and B8 needs to be =sum(b6/b7)

I think I need to tell it to perform these forumlas before pasting
special,
but I don't know how. If you need me to paste the code I have that's no
problem.

Thanks for your help in advance,
Cathy

"Niek Otten" wrote:

Hi Cathy,

A bit more info might do:

What exactly are your formulas? Are any macros involved?
What do you mean by "then changes the formulas"? How do you do that?
Do you see results in the cells which "doesn't perform the formula" or do
you see the formula?
etc....

--
Kind regards,

Niek Otten

"Cathy W" wrote in message
...
Hi. I have a template that takes cell contents from another workbook
and
then changes the formulas to get those contents into values on a save.
I
then have formulas inside the spreadsheet that need to be performed
based
on
what is put in the cells it populates from the other workbook. If I
just
say
=sum(H26/G26), it doesn't perform the formula when H26 and G26 are
populated.


Any ideas?

Cathy

Calculating values...
 

Thanks for the help...I managed to get the calculation to work. I think I
may have been putting in the wrong cell and it was trying to add together a
numeric field and a text field.

Merry Christmas!

Cathy

"Niek Otten" wrote:

Does "Application.Calculate" help?

--
Kind regards,

Niek Otten

"Cathy W" wrote in message
...
Thanks for the reply Niek..I am doing everything I need to do through code
in
the background. The user double clicks the template and it opens, then an
open dialog appears and asks them to choose the file in which to get the
values from. This filename is then stored in cell A1. Then, this
populates
the formulas in the spreadsheet with the values from certain cells. The
forumla to get the values from the other workbook is as
follows:=INDIRECT("'[" & A1& "]dos2'!K9"). Then in the same step it takes
all the values that were copied from the other workbook and pastes
special -
values so that when the user saves the file they can send it having no
like
to any other file. After the paste special, the save as dialog appears
for
them to save the file. The loop hole is that I have forumlas that are
based
on the values that are bought in by the formulas above. For example,

B6 contains =INDIRECT("'[" & A1& "]dos2'!K9")
B7 contains =INDIRECT("'[" & A1& "]dos2'!K10")
and B8 needs to be =sum(b6/b7)

I think I need to tell it to perform these forumlas before pasting
special,
but I don't know how. If you need me to paste the code I have that's no
problem.

Thanks for your help in advance,
Cathy

"Niek Otten" wrote:

Hi Cathy,

A bit more info might do:

What exactly are your formulas? Are any macros involved?
What do you mean by "then changes the formulas"? How do you do that?
Do you see results in the cells which "doesn't perform the formula" or do
you see the formula?
etc....

--
Kind regards,

Niek Otten

"Cathy W" wrote in message
...
Hi. I have a template that takes cell contents from another workbook
and
then changes the formulas to get those contents into values on a save.
I
then have formulas inside the spreadsheet that need to be performed
based
on
what is put in the cells it populates from the other workbook. If I
just
say
=sum(H26/G26), it doesn't perform the formula when H26 and G26 are
populated.


Any ideas?

Cathy