What cause this message in Excel (Excel cannot complete this task with available resources. Choose less data or close other applications)?
The above memory error messages can be very generic and don't always identify the real cause of the issue. However, if your file is large or contains a large amount of features, it is possible you are running low on available memory resources.
Before we explore the more common reasons for the memory errors, it good to understand Excel's limitations
Solution:
1.Open Excel
2.click On File tab and then click Info.
3.Check for issue --> inspect Document
4.inspect ( The application will inspect your excel to found hidden row and column and other issue)
5.select empty row and column and delete them.
good luck.
for more info please see the picture below.
No comments