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