Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 110
Default Excel 2007 Not Responding

My 2007 version of Excel is unusable. Whenver I make an update, even
something as simple as changing the font size in a cell or cells it takes
forever. As soon as I hit the enter key I get the hourglass, within seconds
a totally white screen with "Excel Not Responding" at the top pops up. If I
look in task manager it shows two occurrences of the task as follows:

TASK Status
Myspreadsheet(Not Responding) Not Responding
Myspreadsheet Not Responding

The task will eventually finish if I wait long enough.

If I download this same spreadsheet to a maching with Excel 2003 the
response time is excellent, I want only seconds or a fraction thereof.

This happens with every action I take.

Yesterday I uninstalled my Office Professional 2007 and reinstalled, I
donwloaded all maintenance and restarted my machine. I then opened my
spreadsheet, clicked on a group of cells, and attempted to change the font
size. I was literally hung up for 20 minutes. Same problem...

Any ideas?
tln





  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,480
Default Excel 2007 Not Responding

Hi Terri

If you are using whole columns, then things are slower with over 1 million
cells to format, compared with 65536.

What happens when you choose a smaller range and apply formatting, is it not
responding then?

--
Regards
Roger Govier



"Terri" wrote in message
...
My 2007 version of Excel is unusable. Whenver I make an update, even
something as simple as changing the font size in a cell or cells it takes
forever. As soon as I hit the enter key I get the hourglass, within
seconds
a totally white screen with "Excel Not Responding" at the top pops up. If
I
look in task manager it shows two occurrences of the task as follows:

TASK Status
Myspreadsheet(Not Responding) Not Responding
Myspreadsheet Not Responding

The task will eventually finish if I wait long enough.

If I download this same spreadsheet to a maching with Excel 2003 the
response time is excellent, I want only seconds or a fraction thereof.

This happens with every action I take.

Yesterday I uninstalled my Office Professional 2007 and reinstalled, I
donwloaded all maintenance and restarted my machine. I then opened my
spreadsheet, clicked on a group of cells, and attempted to change the font
size. I was literally hung up for 20 minutes. Same problem...

Any ideas?
tln







  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 110
Default Excel 2007 Not Responding

Hi Roger,

These are very small files < 600 rows and only 9 columns. It does contain
links to another worksheet that is smaller yet. Yesterday I clicked on 12
cells and attempted to change the font size from 10 to 12 this took over an
hour to complete.

I'm quite certain that the file was originally created on a machine running
Office 2003. Not sure if this has any bearing on the situation.

tln


"Roger Govier" wrote:

Hi Terri

If you are using whole columns, then things are slower with over 1 million
cells to format, compared with 65536.

What happens when you choose a smaller range and apply formatting, is it not
responding then?

--
Regards
Roger Govier



"Terri" wrote in message
...
My 2007 version of Excel is unusable. Whenver I make an update, even
something as simple as changing the font size in a cell or cells it takes
forever. As soon as I hit the enter key I get the hourglass, within
seconds
a totally white screen with "Excel Not Responding" at the top pops up. If
I
look in task manager it shows two occurrences of the task as follows:

TASK Status
Myspreadsheet(Not Responding) Not Responding
Myspreadsheet Not Responding

The task will eventually finish if I wait long enough.

If I download this same spreadsheet to a maching with Excel 2003 the
response time is excellent, I want only seconds or a fraction thereof.

This happens with every action I take.

Yesterday I uninstalled my Office Professional 2007 and reinstalled, I
donwloaded all maintenance and restarted my machine. I then opened my
spreadsheet, clicked on a group of cells, and attempted to change the font
size. I was literally hung up for 20 minutes. Same problem...

Any ideas?
tln








  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,480
Default Excel 2007 Not Responding

Hi

What happens if you save in .xlsx format, close and then reopen the files?
Does this have any effect upon the speed?

--
Regards
Roger Govier



"Terri" wrote in message
...
Hi Roger,

These are very small files < 600 rows and only 9 columns. It does contain
links to another worksheet that is smaller yet. Yesterday I clicked on
12
cells and attempted to change the font size from 10 to 12 this took over
an
hour to complete.

I'm quite certain that the file was originally created on a machine
running
Office 2003. Not sure if this has any bearing on the situation.

tln


"Roger Govier" wrote:

Hi Terri

If you are using whole columns, then things are slower with over 1
million
cells to format, compared with 65536.

What happens when you choose a smaller range and apply formatting, is it
not
responding then?

--
Regards
Roger Govier



"Terri" wrote in message
...
My 2007 version of Excel is unusable. Whenver I make an update, even
something as simple as changing the font size in a cell or cells it
takes
forever. As soon as I hit the enter key I get the hourglass, within
seconds
a totally white screen with "Excel Not Responding" at the top pops up.
If
I
look in task manager it shows two occurrences of the task as follows:

TASK Status
Myspreadsheet(Not Responding) Not Responding
Myspreadsheet Not Responding

The task will eventually finish if I wait long enough.

If I download this same spreadsheet to a maching with Excel 2003 the
response time is excellent, I want only seconds or a fraction thereof.

This happens with every action I take.

Yesterday I uninstalled my Office Professional 2007 and reinstalled, I
donwloaded all maintenance and restarted my machine. I then opened my
spreadsheet, clicked on a group of cells, and attempted to change the
font
size. I was literally hung up for 20 minutes. Same problem...

Any ideas?
tln










  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 110
Default Excel 2007 Not Responding

Roger

I've tried this many times but thought I'd do it once again. Saved my
spreadsheet as 1997-2203 closed and reopened the file , did a click in upper
left corner to highlight all cells and changed font size. Same result, I
received the plain white screen with my File Name[Compatibility Mode] (Not
Responding). I did this about five minutes ago and I'm still locked out.
Probably will be for a long time now.

--
tln


"Roger Govier" wrote:

Hi

What happens if you save in .xlsx format, close and then reopen the files?
Does this have any effect upon the speed?

--
Regards
Roger Govier



"Terri" wrote in message
...
Hi Roger,

These are very small files < 600 rows and only 9 columns. It does contain
links to another worksheet that is smaller yet. Yesterday I clicked on
12
cells and attempted to change the font size from 10 to 12 this took over
an
hour to complete.

I'm quite certain that the file was originally created on a machine
running
Office 2003. Not sure if this has any bearing on the situation.

tln


"Roger Govier" wrote:

Hi Terri

If you are using whole columns, then things are slower with over 1
million
cells to format, compared with 65536.

What happens when you choose a smaller range and apply formatting, is it
not
responding then?

--
Regards
Roger Govier



"Terri" wrote in message
...
My 2007 version of Excel is unusable. Whenver I make an update, even
something as simple as changing the font size in a cell or cells it
takes
forever. As soon as I hit the enter key I get the hourglass, within
seconds
a totally white screen with "Excel Not Responding" at the top pops up.
If
I
look in task manager it shows two occurrences of the task as follows:

TASK Status
Myspreadsheet(Not Responding) Not Responding
Myspreadsheet Not Responding

The task will eventually finish if I wait long enough.

If I download this same spreadsheet to a maching with Excel 2003 the
response time is excellent, I want only seconds or a fraction thereof.

This happens with every action I take.

Yesterday I uninstalled my Office Professional 2007 and reinstalled, I
donwloaded all maintenance and restarted my machine. I then opened my
spreadsheet, clicked on a group of cells, and attempted to change the
font
size. I was literally hung up for 20 minutes. Same problem...

Any ideas?
tln













  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,480
Default Excel 2007 Not Responding

Hi Terri

I was suggesting saving it in XL2007 .xlxs format, then closing and
re-opening.
If your machine ever comes back to you, you may want to try this.

--
Regards
Roger Govier



"Terri" wrote in message
...
Roger

I've tried this many times but thought I'd do it once again. Saved my
spreadsheet as 1997-2203 closed and reopened the file , did a click in
upper
left corner to highlight all cells and changed font size. Same result, I
received the plain white screen with my File Name[Compatibility Mode] (Not
Responding). I did this about five minutes ago and I'm still locked out.
Probably will be for a long time now.

--
tln


"Roger Govier" wrote:

Hi

What happens if you save in .xlsx format, close and then reopen the
files?
Does this have any effect upon the speed?

--
Regards
Roger Govier



"Terri" wrote in message
...
Hi Roger,

These are very small files < 600 rows and only 9 columns. It does
contain
links to another worksheet that is smaller yet. Yesterday I clicked
on
12
cells and attempted to change the font size from 10 to 12 this took
over
an
hour to complete.

I'm quite certain that the file was originally created on a machine
running
Office 2003. Not sure if this has any bearing on the situation.

tln


"Roger Govier" wrote:

Hi Terri

If you are using whole columns, then things are slower with over 1
million
cells to format, compared with 65536.

What happens when you choose a smaller range and apply formatting, is
it
not
responding then?

--
Regards
Roger Govier



"Terri" wrote in message
...
My 2007 version of Excel is unusable. Whenver I make an update, even
something as simple as changing the font size in a cell or cells it
takes
forever. As soon as I hit the enter key I get the hourglass, within
seconds
a totally white screen with "Excel Not Responding" at the top pops
up.
If
I
look in task manager it shows two occurrences of the task as
follows:

TASK Status
Myspreadsheet(Not Responding) Not Responding
Myspreadsheet Not Responding

The task will eventually finish if I wait long enough.

If I download this same spreadsheet to a maching with Excel 2003 the
response time is excellent, I want only seconds or a fraction
thereof.

This happens with every action I take.

Yesterday I uninstalled my Office Professional 2007 and reinstalled,
I
donwloaded all maintenance and restarted my machine. I then opened
my
spreadsheet, clicked on a group of cells, and attempted to change
the
font
size. I was literally hung up for 20 minutes. Same problem...

Any ideas?
tln













Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 is SLOW in responding Dick Charts and Charting in Excel 4 September 19th 07 10:53 AM
excel 2007 Not Responding Selcuk Excel Discussion (Misc queries) 0 May 7th 07 11:21 PM
Excel 2007 Not Responding Message Frustrated In Atlanta Excel Discussion (Misc queries) 0 April 16th 07 02:12 PM
excel 2007 stops responding MarcDS Setting up and Configuration of Excel 3 March 24th 07 10:26 AM
Excel - Not responding help Anthony Excel Discussion (Misc queries) 8 July 19th 05 11:30 PM


All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"