Upload Excel to Sharepoint - VisualCron

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

Welcome Guest! To enable all features please Login or Register.

klewis10367
Paid support Topic Starter

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

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

Support
Official 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!