|
Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

spreadsheet cell refresh from Wdata

Answered
0

Comments

1 comment

  • Jeff Hickey

    Hi Ganesh, if you are using a connected sheet to a Wdata query, then it is an all or nothing operation when the refresh button is clicked. This is by design to maintain data integrity. You could use Chains or the Spreadsheet API to programmatically write to specific sections of sheets. However, the cells you intend to write to must not already be locked such as by a connection to a query.

    0

Please sign in to leave a comment.