Upload Excel to Sharepoint - VisualCron - Forum

Community forum

klewis10367
2020-04-07T15:26:46Z
Is there way to Refresh, Not Calculate, an Excel Spreadsheet before using the Upload to SharePoint task?
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