Windows 7/Excel 2010 problem
I bought a new HP Pavilion dv6 computer in December. It came with Windows 7. I purchased Microsoft Office 2010 and loaded it on the new computer. I have always used Word and Excel to create merge document and NEVER had an issue with my old computer (OS was Windows XP/Office 2003). The issue is that when I do a mail merge using Word and Excel, I have memory issues. If I'm running a merge -- even if I have no other programs open -- I cannot open any other Excel files. I will often get a message that says : Excel cannot complete this task with available resources. Choose less data or close other application." Sometimes there are no other applications running besides Excel and Word. I have contacted Microsoft; they say it's an HP problem. I have contacted HP; they say it's a Microsoft problem. Both companies have offered to help -- for a fee. The computer is less than a year old! Why should I have to pay someone to fix a problem that has existed since day 1?? If anyone can help, I'd be very grateful. Thanks! P.S. Yes, I am up to date on all the Microsoft updates.MC
September 1st, 2011 3:19pm

how much RAM is on the new machine? are you using the 32-bit or the 64-bit version of office? Windows MVP, XP, Vista, 7. Expanding into Windows Server 2008 R2, SQL Server, SharePoint etc. My page on Video Card Problems is now my most popular landing page. My Page on SSD is now #2. See my gaming site for game reviews etc. Developer | Windows IT | Chess | Economics | Hardcore Games | Vegan Advocate | PC Reviews
Free Windows Admin Tool Kit Click here and download it now
September 1st, 2011 3:32pm

I'm not sure what the solution for this is, so let's wait for someone who knows about this to respond. In case posting here doesn't work out, please post this question in the Office forums to get more qualified answerers on the subject. Office Forums: http://answers.microsoft.com/en-us/office Hope it helps!Kunal D Mehta - a Windows Server Enthusiast | My first TechNet Wiki Article
September 3rd, 2011 8:45am

Hi, You may refer to the following thread for reference: Excel cannot complete this task with available resources. Choose less data or close other applications http://social.technet.microsoft.com/Forums/en-US/excel/thread/e0b82807-24f5-42b0-aaeb-3f2bc9e94dc2/ As Kunal said, it is recommended to post at Excel forum: Excel IT Pro Discussions Forum Alex ZhaoPlease remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Free Windows Admin Tool Kit Click here and download it now
September 5th, 2011 5:55am

This was in a different thread and worked for me as well: Hi Craved. We were having issues with sorting data in either small or large Excel files. We have machines running Windows 7-64bit / Office 2010 SP1-32bit with all current Windows / Offrice updates applied. The answer to our problem was to remove the following Security Update for MS Excel 2010 - KB2597166. Tested by attempting to open the spread sheet on various PC's and the one's with the above update always failed. We removed the update and since then we haven't had the problem. Changed it to hidden in Windows updates too so the user can accidently install it again. Hope this helps. Wee Dod.
June 12th, 2012 1:57pm

This was in a different thread and worked for me as well: Hi Craved. We were having issues with sorting data in either small or large Excel files. We have machines running Windows 7-64bit / Office 2010 SP1-32bit with all current Windows / Offrice updates applied. The answer to our problem was to remove the following Security Update for MS Excel 2010 - KB2597166. Tested by attempting to open the spread sheet on various PC's and the one's with the above update always failed. We removed the update and since then we haven't had the problem. Changed it to hidden in Windows updates too so the user can accidently install it again. Hope this helps. Wee Dod. Microsoft Office 2010, and Excel 2010, are neither a Windows 7 feature nor an integral part of Windows 7. Any and all of Office 2010 are installed programs. Suggest you post in the appropriate Office forum @ http://answers.microsoft.com/en-us The Excel forum is @ http://social.technet.microsoft.com/Forums/en-US/excel/Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Free Windows Admin Tool Kit Click here and download it now
June 12th, 2012 4:10pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics