Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Excel 2010 cannot complete this task..Shared files

Mar 11, 2015 3:39AM PDT

The layout
A server in an office connects 5 computers running windows 7 and using MS office plus 2010(32bit) and 1 computer running XP using MS office plus 2007(32bit), they are all 64bit OS's besides xp. They share many spreadsheets that are opened, edited and updated simultaneously off the server. Since the spreadsheets need to be referred to each other, 2 up to 5 excel files must be opened on the computer I'm working on.

Discussion is locked

- Collapse -
Clarification Request
Continued...
Mar 11, 2015 3:40AM PDT

I'm working with a computer that has the following error during reading and writing to spreadsheets.
"Excel cannot complete this task with available resources choose less data or close Other applications"
This error occurs simply because excel has used up all the resources. However I'd like to avoid the simple "close redundant spreadsheets" because sooner or later they will need to be used.

The problem is that its only one computer that is having this problem all other computers don't get this error despite having equal amount of spreadsheets opened as the problematic computer. We've upgraded the ram and graphics card on that computer yet problem persists. I'm aware of the 2gb ram access restriction office 32bit has.

The only solution I can think of would be to install a 64 it version of office on this computer set the default program that opens the file to the 64bit excel version (only for the problematic computer). Will cause errors? Seeing as other computers run 32bit office?

Does anyone know of any other ways of doing this? When the error occurs the file is locked and all data that is entered into the file after that is lost.

Thank you in advanced

- Collapse -
I'm going with no. However
Mar 11, 2015 4:02AM PDT

Your IT staff or support should test the 64 bit idea. Why I don't write it to be a solution is that many other folk found the 64 bit version to have other issues such as add on compatibility, etc.

There's another way to deal with this and that is to move away from the spreadsheet. Once data grows to this size it's customary to move to a database.
Bob

- Collapse -
Thanks for your reply
Mar 11, 2015 4:43AM PDT

I've thought about that but the migration is huge, I am IT and I'm just getting a copy of the 64bit to try tomorrow, I'm thinking if only the simplest sheets were opened in 64bit that would free up the space for the more complicated stuff to use.