Thread: PI Add-In
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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