What's causing this error message?

  • Thread starter Thread starter James LaChance
  • Start date Start date
J

James LaChance

I'm using v02 and when I try to enter the options menu and
select 'ok' or move to another options tab, I get the
following error:

'The number must be between 1 & 32767. Try again by
entering a # in this range'.

It's only this workbook because all other spreadsheets are
fine. I'm not inputing any type of # or range so I'm not
sure why this is occuring. Any thoughts? Is this a bug
of some type? Thanks.
 
Hi James

Try to reset your menu bar
Right click on the menubar and choose customize

Under Toolbars select the worksheet menubar
and click on reset on the right
Note : You lose all the things you have changed in the menu bar



If this not working try this

This can be a corrupt or bloated toolbar file
The .xlb file has all Toolbar customization in it.

Close Excel
Do a search for .xlb in windows
Rename the file you find (my file is named Excel10.xlb in 2002)
Start Excel

Deleting the file or renaming will do no harm on your system
Excel will create a new one for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
This file is important (backup it so you can restore it)
 
Thanks for the tip but no luck on those approaches.

-----Original Message-----
Hi James

Try to reset your menu bar
Right click on the menubar and choose customize

Under Toolbars select the worksheet menubar
and click on reset on the right
Note : You lose all the things you have changed in the menu bar



If this not working try this

This can be a corrupt or bloated toolbar file
The .xlb file has all Toolbar customization in it.

Close Excel
Do a search for .xlb in windows
Rename the file you find (my file is named Excel10.xlb in 2002)
Start Excel

Deleting the file or renaming will do no harm on your system
Excel will create a new one for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
This file is important (backup it so you can restore it)



--
Regards Ron de Bruin
http://www.rondebruin.nl


"James LaChance" <[email protected]>
Click to expand...
wrote in message [email protected]...
 
About the only spot that looks like it accepts numbers that big is on the
Tools|options|calculation tab (iteration box).

You could try this to see if it helps:

Open the workbook (don't touch tools|options).

Instead hit alt-f11 (to get to the VBE)
then hit ctrl-g to see the immediate window

Type this in and hit enter:
application.maxiterations = 100

Then back to excel and tools|options and see what happens.

===
If it didn't help, maybe reregistering excel will help:

close excel
windows start button|Run
excel /unregserver
followed by
excel /regserver

It resets excel's registry entries to factory defaults.

===
If that didn't help, maybe cleaning up the excel entries in the registry would
work.
 
Back
Top