How to fix Stockhistory function in office 365

Question

For the last few days the stock history function in excel is not working properly. how do I rectify the same. it says server problem and work is ongoing to fix it but it has been almost 5 days it is not working properly.

Please guide.

Answer 1

The issue with the StockHistory function in Excel may be related to server problems, as you mentioned. Unfortunately, there is no specific troubleshooting guidance for the StockHistory function in the provided context. However, here are some general steps you can take to troubleshoot issues with Excel functions:

1. Check Internet Connection: Ensure that your internet connection is stable, as the StockHistory function relies on online data.
2. Update Excel: Make sure your Excel application is up to date. Sometimes, issues are resolved in newer updates.
3. Restart Excel: Close and reopen Excel to see if the issue persists.
4. Try Different Data: Test the function with different stock symbols to see if the problem is specific to certain data.
5. Wait for Server Issues to Resolve: If the error message indicates ongoing server issues, it may be best to wait until Microsoft resolves the problem.
6. Contact Support: If the issue continues, consider reaching out to Microsoft Support for further assistance.

If you are still experiencing issues after trying these steps, it may be a good idea to monitor any updates from Microsoft regarding the StockHistory function.

---

References:

• How can I get office 365 to work? - Microsoft Q&A
• Office integration FAQ