#CALC

Question

I have data with around 20,000 columns and if i try using python to import the data i am getting a #CALC error. see below

Answer 1

Hello Baba Prophets

Thank you for posting in Microsoft Community.

It seems like you are having an issue using the Python in Excel wherein you encountered some error. Let’s work together in finding the best resolution to this issue.

For me to better understand the issue, I’d like to ask a few questions:

• Is this working before?
• What is the version number of your Excel app?

The #CALC error in Excel usually occurs when a formula is unable to calculate a result. In your case, it could be due to the large number of columns in your data. Here are a few steps you can take to resolve this issue:

• Check if any of the formulas in your worksheet are referencing cells that contain errors or are blank. If so, correct those errors or fill in the blank cells.
• Try breaking down your data into smaller chunks and importing them separately. This will help reduce the load on Excel and may prevent the #CALC error from occurring.
• Consider using a different tool or program to import and analyze your data. Python is a powerful tool for data analysis, but it may not be the best option for handling large datasets in Excel.

Ads we all know that Python in Excel is currently in preview and is subject to change based on the feedback. To use this feature, join the Microsoft 365 Insider Program and choose the Beta Channel Insider level.

If you encounter any issues with Python in Excel, please report them by selecting Help > Feedback in Excel.

You may also report this problem directly to our engineers using the link below.

Click here: Open-source libraries and Python in Excel - Microsoft Support

We look forward to your next response.

Regards,

Jason Guer

Microsoft Community Moderator

Answer 2

Thanks so much for the clarification.

Answer 3

Hello Baba Prophets

Good Day!

It is my pleasure to help you with your concern. Thank you for appreciating my initial response. Please do not hesitate to ask the community anytime just in case you have any questions in the future.

Regards,

Jason Guer

Microsoft Community Moderator

Answer 4

is python still working in excel? I was using it and i tried on the sample sheets and all the time i am getting the same error