Solved

Not able to add rows to Excel spreadsheet

Posted on 2013-01-31
7
539 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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

707 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now