PI Add-In
 

I have a spreadsheet that uses the PI add-in. The cells contains PI formulas
and in order to update the data (adds a another row for each day) in the
spreadsheet you have to right click and select Recalculate and resize€¦. I
have been trying to automate this by writing a macro to go to each of these
cells, right click and recalculate (also tried PI Calculated Data) but
when I look in the macro codes (after Im done creating the macro), it does
not recognize the recalculation step. It only show that I selected the
cells. Is there a special code for PI recalculation that I can insert in the
macro editor, or is it just not possible to perform this in a macro?
Thanks for any help you have to offer.

--
Karen

PI Add-In
 

What PI addin are you referring to? PI is a built-in function, and works
normally for me.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Karen" wrote in message
...
I have a spreadsheet that uses the PI add-in. The cells contains PI
formulas
and in order to update the data (adds a another row for each day) in the
spreadsheet you have to right click and select Recalculate and resize.. I
have been trying to automate this by writing a macro to go to each of
these
cells, right click and recalculate (also tried PI Calculated Data) but
when I look in the macro codes (after I'm done creating the macro), it
does
not recognize the recalculation step. It only show that I selected the
cells. Is there a special code for PI recalculation that I can insert in
the
macro editor, or is it just not possible to perform this in a macro?
Thanks for any help you have to offer.

--
Karen

PI Add-In
 

OSI PI and it didn't come standard in my excel...had to have IT associate my
pc with it, then added it in under Tools Add-Ins

I have no problem recalculating manually (meaning, right clicking in cell
and selecting Recalculate), but in trying to automate my spreadsheet (so I
don't have to visit each cell manually) I've tried to set up a macro to do it
but it just won't work. (the tag names/formulas, in the cells, calculate
daily compressor volumes and pressures.)
--
Karen


"Bob Phillips" wrote:

What PI addin are you referring to? PI is a built-in function, and works
normally for me.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Karen" wrote in message
...
I have a spreadsheet that uses the PI add-in. The cells contains PI
formulas
and in order to update the data (adds a another row for each day) in the
spreadsheet you have to right click and select Recalculate and resize.. I
have been trying to automate this by writing a macro to go to each of
these
cells, right click and recalculate (also tried PI Calculated Data) but
when I look in the macro codes (after I'm done creating the macro), it
does
not recognize the recalculation step. It only show that I selected the
cells. Is there a special code for PI recalculation that I can insert in
the
macro editor, or is it just not possible to perform this in a macro?
Thanks for any help you have to offer.

--
Karen

PI Add-In
 

But why do you need a PI addin? It sound as though that addin is not
recalculating, so use the built-in PI.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Karen" wrote in message
...
OSI PI and it didn't come standard in my excel...had to have IT associate
my
pc with it, then added it in under Tools Add-Ins

I have no problem recalculating manually (meaning, right clicking in cell
and selecting Recalculate), but in trying to automate my spreadsheet (so I
don't have to visit each cell manually) I've tried to set up a macro to do
it
but it just won't work. (the tag names/formulas, in the cells, calculate
daily compressor volumes and pressures.)
--
Karen


"Bob Phillips" wrote:

What PI addin are you referring to? PI is a built-in function, and works
normally for me.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Karen" wrote in message
...
I have a spreadsheet that uses the PI add-in. The cells contains PI
formulas
and in order to update the data (adds a another row for each day) in
the
spreadsheet you have to right click and select Recalculate and resize..
I
have been trying to automate this by writing a macro to go to each of
these
cells, right click and recalculate (also tried PI Calculated Data)
but
when I look in the macro codes (after I'm done creating the macro), it
does
not recognize the recalculation step. It only show that I selected the
cells. Is there a special code for PI recalculation that I can insert
in
the
macro editor, or is it just not possible to perform this in a macro?
Thanks for any help you have to offer.

--
Karen

PI Add-In
 

Bob,

I suspect this has nothing to do with pi (i.e. 3.142...), but probably
an add-in from some company called P I (something Institute, or
Industries, or Inc. ???)

Pete

On Mar 14, 1:10*pm, "Bob Phillips" wrote:
But why do you need a PI addin? It sound as though that addin is not
recalculating, so use the built-in PI.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Karen" wrote in message

...



OSI PI and it didn't come standard in my excel...had to have IT associate
my
pc with it, then added it in under Tools Add-Ins

I have no problem recalculating manually (meaning, right clicking in cell
and selecting Recalculate), but in trying to automate my spreadsheet (so I
don't have to visit each cell manually) I've tried to set up a macro to do
it
but it just won't work. (the tag names/formulas, in the cells, calculate
daily compressor volumes and pressures.)
--
Karen

"Bob Phillips" wrote:

What PI addin are you referring to? PI is a built-in function, and works
normally for me.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Karen" wrote in message
...
I have a spreadsheet that uses the PI add-in. *The cells contains PI
formulas
and in order to update the data (adds a another row for each day) *in
the
spreadsheet you have to right click and select Recalculate and resize...
I
have been trying to automate this by writing a macro to go to each of
these
cells, right click and recalculate (also tried PI Calculated Data)
but
when I look in the macro codes (after I'm done creating the macro), it
does
not recognize the recalculation step. *It only show that I selected the
cells. *Is there a special code for PI recalculation that I can insert
in
the
macro editor, or is it just not possible to perform this in a macro?
Thanks for any help you have to offer.

--
Karen- Hide quoted text -

- Show quoted text -