Ever since I installed office 2010 on my Windows 7 machine I have been receiving the following errors:
"Excel Cannot complete this task with available resources. Choose less date or close other applications."
this is followed by a statement that the file cannot be opened or corrupted and then repeats the message above about 10 times.
This error is all over the web without much resolution.
The error occurs after an excel sheet is already opened and I try to open another one through windows explorer. The sheets are very small. there is no data connections or macros in these sheets.
The only work around is to first open another excel then go to open file and locate the file I need to open. This opens the same file without any problems. This makes no sense because excel just told me I didn't have enough memory followed by an error message stating the file was corrupt.
This happens on all excel files not specific ones. It's very frustrating. I see this documented all over the place with no real solutions. Most of the answers here seem to point to older versions of Office. I believe this may be related to office 2010 and windows 7.