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
Kwonjube

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
Ranger4

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
Reply

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




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
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
Creating a Task in Outlook 2010 from a Word 2010 Document
Hello All Win 7 Prof 32 bit Office 2010 I've been trying to create a Task in Outlook from a Word Document that I have created on this computer. The idea is that a shortcut to the document is created as an Outlook Task. Click on the shortcut, and voila - there is the document. The...
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
Task Scheduler wait for action to complete
Hi- I am using Task Scheduler to run an .exe and then a .bat file at a scheduled time each day. However, the run time for the .exe process varies between seconds and hours and I need to be sure that the first process is finished before the second Action (.bat file) is initiated by Task...
General Discussion


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 02:32.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App