PI Add-In

[Karen]

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.

 

[Bob Phillips]

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]

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.)

 

[Bob Phillips]

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)

 

[Pete_UK]

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