Excel 97 Drop Down Menus-SLOW

brendawidner · Apr 18th, 2002, 10:38 AM

Recently, when I click on a menu item, it takes forever for the choice to "load". In the past, I could click FILE and at that point, all items under FILE showed up. Now when I click FILE, New shows up, then Open shows up, then close shows up, then save shows up--line item by line item they begin to show up. This is happening with all menu items. How can I stop this madness>

Mark O'Brien · Apr 18th, 2002, 10:43 AM

How big is your excel file? Or does this just happen in all of your files? What's the spec of your machine (RAM, OS, etc?

One suggestion that's been kicked around here recently, and I don't know if it applies in this scenario, is to have a look in your C:Temp folder to see how much garbage is in there. Look in particular for files with the extension *.emf. Deleting unnecessary files from here may help.

brendawidner · Apr 18th, 2002, 01:05 PM

I have removed all garbage files from the temp folder. Memory is not a problem. There is very little stored on the hard drive. The problem still exists.

Chris Davison · Apr 18th, 2002, 03:24 PM

Brenda,

take a look at :

view
toolbars
customise

and see what your "menu animations" are set at

(personally, I use "none")

if it's anything else, see how this combines with your graphics capabilities in :

start
settings
control panel
system
performance
graphics

Persoanlly, I use "full"

If your'e using sliding menus and your praphics are set to low, this might be slowing it down a touch.......

probably not much help, but worth checking

Jack in the UK · Apr 18th, 2002, 03:32 PM

i have worked hard on the topic of SLOW...

check this the sheet the drop down is in for formulas..

OK simple cheats way, more secrets..

crtl+g
select special
tick formula and press enter

you see the black cells as these are ones with formulas in.

Oh page zoom 26% so you can see it all now squint and see the prcent of black cells .. looks bad,,, needs addressing even if jst one column...

do the sane to drop down range if diff sheet...

tidy this up if needs be,,, a different idea...

Apr 18th, 2002, 10:43 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	How big is your excel file? Or does this just happen in all of your files? What's the spec of your machine (RAM, OS, etc? One suggestion that's been kicked around here recently, and I don't know if it applies in this scenario, is to have a look in your C:Temp folder to see how much garbage is in there. Look in particular for files with the extension *.emf. Deleting unnecessary files from here may help. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 18th, 2002, 03:24 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Brenda, take a look at : view toolbars customise and see what your "menu animations" are set at (personally, I use "none") if it's anything else, see how this combines with your graphics capabilities in : start settings control panel system performance graphics Persoanlly, I use "full" If your'e using sliding menus and your praphics are set to low, this might be slowing it down a touch....... probably not much help, but worth checking __________________ :: Pharma Z - Family drugstore ::

Apr 18th, 2002, 03:32 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	i have worked hard on the topic of SLOW... check this the sheet the drop down is in for formulas.. OK simple cheats way, more secrets.. crtl+g select special tick formula and press enter you see the black cells as these are ones with formulas in. Oh page zoom 26% so you can see it all now squint and see the prcent of black cells .. looks bad,,, needs addressing even if jst one column... do the sane to drop down range if diff sheet... tidy this up if needs be,,, a different idea... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 10:38 AM	#1
brendawidner New Member Join Date: Apr 2002 Posts: 8	Recently, when I click on a menu item, it takes forever for the choice to "load". In the past, I could click FILE and at that point, all items under FILE showed up. Now when I click FILE, New shows up, then Open shows up, then close shows up, then save shows up--line item by line item they begin to show up. This is happening with all menu items. How can I stop this madness>

Apr 18th, 2002, 01:05 PM	#3
brendawidner New Member Join Date: Apr 2002 Posts: 8	I have removed all garbage files from the temp folder. Memory is not a problem. There is very little stored on the hard drive. The problem still exists.