Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


klewis10367
2020-04-07T15:26:46Z
Is there way to Refresh, Not Calculate, an Excel Spreadsheet before using the Upload to SharePoint task?
Sponsor
Forum information
Support
2020-04-14T08:47:27Z
Originally Posted by: klewis10367 

Is there way to Refresh, Not Calculate, an Excel Spreadsheet before using the Upload to SharePoint task?



There is currently no "simple" way of doing this. We are however thinking about adding a function for this at some point.

What you can do in the meanwhile is use the Office Macro Task and write a script/function that uses the Refresh function in excel and use that for your purpose.
Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
Scroll to Top