• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 561
  • Last Modified:

Not able to add rows to Excel spreadsheet

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
optimus_nz
Asked:
optimus_nz
  • 3
  • 2
1 Solution
 
redmondbCommented:
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
 
ChanduNelluriCommented:
You may also try options mentioned in following article.

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

-Chandu
0
 
optimus_nzAuthor Commented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
optimus_nzAuthor Commented:
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
 
redmondbCommented:
Thanks, optimus_nz. To helps others who may be in the same situation, which scanner did you use?
0
 
optimus_nzAuthor Commented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now