Skip to main content
yoohooos12-Amethyst
12-Amethyst
June 2, 2022
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?

 

 

terryhendicottAnswer
21-Topaz II
June 2, 2022

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

terryhendicott21-Topaz II
21-Topaz II
June 2, 2022

Hi,

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

Cheers

Terry

Translate
yoohooos12-AmethystAuthor
12-Amethyst
June 2, 2022

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

Translate
terryhendicott21-Topaz IIAnswer
21-Topaz II
June 2, 2022

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