Dear all,
I´m working with this reference Exploration API functions – PAx API and trying to find a function that could replace all TM1-Formulars within a workbook with values. Somehow like a snapshot. I`ve got a "standard" VBA sub that replaces all cells with values that contains "DBR", "DBRA", "VIEW",...
For some reason that functionality wokred just fine for perspectives but with PAfE it`s just working for the visible part of one worksheet and not for the whole workbook including hidden cells. I thought maybe there is a standard functionality for that issue!?
Thanks a lot!
br
Eric
Hi Eric,
If you do not need to automate, use the snapshot buttons on the ribbon - these are fast and work well.
If you do want to automate, have a look at "unlinking"