Solved

Not able to add rows to Excel spreadsheet

Posted on 2013-01-31
7
543 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
  • 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

832 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