Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Excel 2008 hanges when deleting cells or rows

 
   Windows Help (Home) -> Microsoft Excel RSS
Next:  How can I create a monthly planner  
Author Message
rrj

External


Since: Dec 5, 2008
Posts: 1



(Msg. 1) Posted: Fri Dec 05, 2008 8:10 am
Post subject: Excel 2008 hanges when deleting cells or rows
Archived from groups: microsoft>public>excel (more info?)

Anyone know of a problem with Excel 2008 hanging when deleting?
I have a large spreadsheet with all my banking history in it
Today after doing a statement download to a .csv and then cutting and
pasting into the spreadsheet I tried to delete a few repeated lines
and got an hourglass. Eventually I had to kill off Excel.
I repeated the cut and paste then did the same delete and had exactly
the same problem. deleting just a single cell does the same.
Next time I saved after the paste, shut down Excel and restarted
again, same problem.
I can navigate around the sheet OK, edit cells OK, but as soon as I
try a delete it hangs.
The file was Excel 2003 format but I then saved it as 2007 format but
still have the same problem.
It only happens in one tab of the spreadsheet, not in any of the
others.
Its basically just numbers formatted to 2 decimal places and some
simple additions. No macros, no complex formlae and only 8 clums woide
by a few hundred deep.
Any ideas?

 >> Stay informed about: Excel 2008 hanges when deleting cells or rows 
Back to top
Login to vote
Simon Murphy

External


Since: Dec 8, 2008
Posts: 1



(Msg. 2) Posted: Mon Dec 08, 2008 10:24 pm
Post subject: Re: Excel 2008 hanges when deleting cells or rows
Archived from groups: per prev. post (more info?)

What add-ins have you got loaded?
Also if you have the Google toolbar (and probably others) installed that
can kill Excel 2007 performance.

[URL="http://www.dailydoseofexcel.com/archives/2007/12/18/google-toolbar-slows-excel/"]http://www.dailydoseofexcel.com/archives/2007/12/18/google-toolbar-slows-excel/[/URL]

Cheers
Simon
Excel development website: [URL="http://www.codematic.net"]www.codematic.net[/URL]


rrj wrote:
> Anyone know of a problem with Excel 2008 hanging when deleting?
> I have a large spreadsheet with all my banking history in it
> Today after doing a statement download to a .csv and then cutting and
> pasting into the spreadsheet I tried to delete a few repeated lines
> and got an hourglass. Eventually I had to kill off Excel.
> I repeated the cut and paste then did the same delete and had exactly
> the same problem. deleting just a single cell does the same.
> Next time I saved after the paste, shut down Excel and restarted
> again, same problem.
> I can navigate around the sheet OK, edit cells OK, but as soon as I
> try a delete it hangs.
> The file was Excel 2003 format but I then saved it as 2007 format but
> still have the same problem.
> It only happens in one tab of the spreadsheet, not in any of the
> others.
> Its basically just numbers formatted to 2 decimal places and some
> simple additions. No macros, no complex formlae and only 8 clums woide
> by a few hundred deep.
> Any ideas?

 >> Stay informed about: Excel 2008 hanges when deleting cells or rows 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
move 2008 excel program to 2009 - I would like to move a excel sheet of 2008 information to the same dates but 2009

Filter rows/transactions to another sheet. - Hi I have a sheet with 6500 transactions in rows. Each row contains an account no, amount, etc I would like to have Excel automatically copy all the rows/transactions on each account to a separate sheet in the same workbook (one account per sheet)....

Macro to insert rows based on user selection - I have a macro that allows a user to insert one or more rows based on a user input box. This allows me to control which formulae get copied into the new cells. The macro works fine UNLESS the user scrolls around the screen before making their selection...

Adding up several cells - I'm sure this is really easy but I am getting into circular reference errors - I have two cells - one is a running total the other a user input figure that needs to be appended to the running total every time. so if the running total stands at 0, the....

Unlocking Cells - Hi, I'd like to know if there's a simple way to unlock or lock cells. I'm not sure if "Lock" is the correct term here. For example, if you have a formula that has C$14. Is there an easy way to unlock (remove the "$") from the formul...
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]