Skip to main content
yoohooos12-Amethyst
12-Amethyst
Jun 2, 2022 1:02 AM UTC
Solved

Had to refresh(F5) to get the the sheet to load. How to fix this?

I used to have this problem when I had regular sheet. However, now, I'm using API and input everything using API, but my output isn't refreshing. I have to open, refresh and open again by hand. Anyone faced this issue before?

 

 

terryhendicott
terryhendicottAnswer
21-Topaz II
Jun 2, 2022 2:51 AM UTC

Hi,

API documentation in help is not really helpful in difference between WS.ResumeCalculation and WS.Synchronize

 

PauseCalculation()—Pauses the calculation.
ResumeCalculation()—Resumes the calculation.

Synchronize()—Synchronizes, or recalculates, the worksheet.

 

Cheers

Terry

View in thread

5 replies

terryhendicott
terryhendicott21-Topaz II
21-Topaz II
Jun 2, 2022 1:46 AM UTC

Hi,

Try the WS.ResumeCalculation statement to refresh after input via API.

Cheers

Terry

Translate
yoohooos12-AmethystAuthor
12-Amethyst
Jun 2, 2022 1:48 AM UTC

What are the differences between WS.ResumeCalculation and WS.Synchronize? 

Translate
terryhendicott
terryhendicott21-Topaz IIAnswer
21-Topaz II
Jun 2, 2022 2:51 AM UTC

Hi,

API documentation in help is not really helpful in difference between WS.ResumeCalculation and WS.Synchronize

 

PauseCalculation()—Pauses the calculation.
ResumeCalculation()—Resumes the calculation.

Synchronize()—Synchronizes, or recalculates, the worksheet.

 

Cheers

Terry

Translate
Terms & ConditionsAccessibility statement