Hello Community.  Is there something in the Excel workbook metadata that would indicate that a file is a PAfE file vs a regular Excel file?  We are working on an app that works with Excel files and would look to refresh a PAfE file but this refresh would not be required if the file is a regular Excel file.  If there is something, where might I go to find it?

------------------------------
Dean Watts
------------------------------

#PlanningAnalyticswithWatson

Dean,

It depends a bit on what you mean by a PAfE file since there are several different types of reports that you can create in PAfE.  For example, if you're using explorations or quick reports you'll find a bunch of properties in Sheet.CustomProperties that you can key off of to know there's PAfE data on that sheet.  If however you're using Custom or Dynamic Reports then those are entirely formula based and you can't count on anything special in the worksheet properties.  For these types of reports you'll need to use Excel's SpecialCells find feature to try and find a formula that is a DBRW (presumably).  

As an alternative to automating PAfE through VBA we have a product called ReportWORQ that can refresh PAfE workbooks in bulk and in the background.  There is a free trial if you're interested in this route: http://quebit.com/rw

Thank You,
Andy Weiss
QueBIT

------------------------------
Andrew Weiss
------------------------------

Refreshing non-connected content is nearly a no-op, so perhaps you could say a bit more about what/why you're trying to avoid versus say, simply attempting to refresh all books regardless.

Regards,


--
Ted

------------------------------
Ted Phillips
------------------------------