?
Solved

Not able to add rows to Excel spreadsheet

Posted on 2013-01-31
7
Medium Priority
?
555 Views
Last Modified: 2013-03-18
Hi Team

I have a customer with a spreadsheet that he is not able to add rows or columns to. Further more when he opens this spreadsheet it appears to effect other Excel spreadsheets. It is not possible to add rows or columns to other spreadsheets before restarting the computer.

The customer is running Excel 2010 on a Windows 7 machine. The spreadsheet is a Microsoft Excel Worksheet (not 97-2003).

The first message you receive is that Excel is performing "a large operation" and will take a significant amount of time to complete followed by the yes and cancel options. After this an error message pops up saying "Excel cannot complete this task with available resources. Choose less data or close other applications"

I have tested this on both his machine and my own. Both are i5's with a fair amount of ram.

Hoping somebody has run into this issue before. Any suggestions would be appreciated

Thanks
0
Comment
Question by:optimus_nz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 Comments
 
LVL 26

Expert Comment

by:redmondb
ID: 38841993
Hi, optimus_nz.

Excel is powerful but it still has limits and it looks as if your customer has exceeded at least one.

The ideal situation would be for you to post a copy of the file here. However, if the file is too sensitive then please do the following...
 - On each sheet of the file, unhide all rows and columns, turn off filters. Then hold down the Ctrl key and hit the End key. Excel will activate what it thinks is the last cell. Record the information for each sheet and post it here.
 - Please redact the file by, in each sheet, deleting all data rows except the first one. In that row, delete all data but leave the formulas. Post the resulting file here.
- If you have a Zip utility (e.g. 7-Zip, PKZip, WinRar) and are happy using it then please do the following - open the file in your zip utility. If it displays a list of files and folders including the folder sizes then keep drilling down into the largest folder until you find its biggest file. What is the name of the file and how big is it?
 - Finally, how big is the file?

Thanks,
Brian.
0
 
LVL 4

Expert Comment

by:ChanduNelluri
ID: 38843159
You may also try options mentioned in following article.

http://support.microsoft.com/kb/2655178

-Chandu
0
 

Author Comment

by:optimus_nz
ID: 38924290
Thanks Guys

We will try to recreate at our end, just need the user to send through data .xls files for the pivet tables. Will let you know how we get on.

Thanks.
excel.PNG
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Author Comment

by:optimus_nz
ID: 38982689
We attempted to recreate the spreasheet as suggested by redmondb however we were not able to successfully add rows or columns. We liaise with a Excel expert who believes that the one of the data sections is corrupt but unfortunately due to the sensitive nature of the information we are not able to send the document through to him.  In the end we ran a document scanner and found that the data sheet was corrupt.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 38982769
Thanks, optimus_nz. To helps others who may be in the same situation, which scanner did you use?
0
 

Accepted Solution

by:
optimus_nz earned 0 total points
ID: 38994979
The steps suggested by redmondb were helpfull but didn't solve the issue for us. The issue was solved when we ran the excel spreadsheet scanner over the corrupted file.
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question