Solved

Not able to add rows to Excel spreadsheet

Posted on 2013-01-31
7
541 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
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.

 

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

932 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

9 Experts available now in Live!

Get 1:1 Help Now