Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Excel 2010 cannot complete this task... Error in a shared spreeadsheet

11 Mar 2015   #1

Windows 7
Excel 2010 cannot complete this task... Error in a shared spreeadsheet

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.

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. Thanks in advanced

My System SpecsSystem Spec
11 Mar 2015   #2

Windows 7 Home Premium 64 bit sp1

Hi Kwonjube, welcome to Windows Seven Forums.

It would not be wise to install the 64 bit Office on this computer if other computer need to access these spreadsheets as they will not be compatible if they are all 32 bit.

Have a look at this website as it concerns an Office 2010 update that may be causing your problem.

"Excel cannot complete this task with available resources" after installing MS12-030 (updated) - The Microsoft Excel Support Team Blog - Site Home - TechNet Blogs
My System SpecsSystem Spec

 Excel 2010 cannot complete this task... Error in a shared spreeadsheet

Thread Tools

Similar help and support threads
Thread Forum
Can't open an Excel file from a shared drive
A user has tried to open an excel file from a shared drive to enter some data and he is now getting a message saying access denied, contact Admin. I have checked the permissions and he has full access, nothing has changed there. I found that if the file is renamed, he can open it but when it is...
Network & Sharing
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Shared Excel file won't Save
Hi I set up a second User account for a friend so an office associate can sign in to access a spreadsheet on his PC. From the Admin's account I shared to the new account with Read/Write privileges. I didn't see any higher sharing permissions but really didn't poke around much. So I get a...
Microsoft Office
Excel 2010 Script error popup when getting data from Web
Hi there I sometimes get a script error when getting data from web when using Excel 2010. This seems to depend on the ISP I'm using as I can take the laptop into some Wifi enabled Cafe's and EXCEL gets the data without the error popup. Since I like to run some of these as background...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 04:30.
Twitter Facebook