Skip to main content
Y
yoohooos12-Amethyst
12-Amethyst
June 2, 2022
Solved

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

  • June 2, 2022
  • 1 reply
  • 1978 views

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?

 

 

Best answer by terryhendicott

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

1 reply

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

Hi,

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

Cheers

Terry

Y
yoohooos12-AmethystAuthor
12-Amethyst
June 2, 2022

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

T
21-Topaz II
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

Terms & ConditionsAccessibility statement