Forum Discussion
Dacrim
Jan 03, 2026Copper Contributor
STOCKHISTORY function returns random #CONNECT error
STOCKHISTORY function intermittently returns #CONNECT! errors in Excel Microsoft 365 The same formulas sometimes return valid historical currency data and at other times return #CONNECT! without any change to the workbook Recalculating refreshing or reopening Excel may temporarily fix it The issue affects multiple symbols simultaneously suggesting a backend or service side problem rather than formula syntax Example formula STOCKHISTORY("EUR/USD", start_date, end_date) Is this a known issue or service degradation and is there any recommended workaround. Any official clarification or guidance would be appreciated.
1 Reply
- mathetesGold Contributor
It's working today. Was down for the weekend.