Formula Bar Pref: Strange Error

[Rick Gregory]

After a blissful, error-free month with Office 2004 (11.2) on a new PB G4
with Tiger 11.4.2, I received my first error message today, and a strange
on.

While working on an Excel file, I went to Excel preferences to turn off the
Formula Bar. I later went to turn it back on and received the following
message:

"The number must be between 1 and 32767. Try again entering a number in
this range."

I am now unable to turn the formula bar on in this or any other spreadsheet.

Any ideas?

 

[Bob Greenblatt]

After a blissful, error-free month with Office 2004 (11.2) on a new PB G4
with Tiger 11.4.2, I received my first error message today, and a strange
on.

While working on an Excel file, I went to Excel preferences to turn off the
Formula Bar. I later went to turn it back on and received the following
message:

"The number must be between 1 and 32767. Try again entering a number in
this range."

I am now unable to turn the formula bar on in this or any other spreadsheet.

Any ideas?

That message sounds like it is coming from data validation. Do you get that
error when you try to click the formula bar in the View tab of preferences?

 

[Rick Gregory]

Bob- Yes, it's in the view tab of Preferences. However, it seems to have
stopped now, so I'll carry on. Thx.

 

[CyberTaz]

FWIW, if this just happened the one time, you may have typed something
in a cell, then tried to display the bar without having _entered_ the
value. Perhaps if it had been entered the message would have appeared
then, but the attempt to go on to something else triggered the entering
& gave the impression that the second action triggered the message.
Possible?

Regards |:>)

 

[Rick Gregory]

Taz... Possible, and that was my initial suspicion, but I closed my original
workbook and subsequently opened and/or created several others with the
problem repeating itself. Can't say what was different when Excel finally
permitted me to re-open the formula bar... Thanks for the input.