Re: about the error at Tools->Options of Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Dear Peterson,

Thanks for your reply. Now, all of computers of my company are using
Microsoft Office XP. On another computer which hasn't this error, At
Tools|Options|Cacultation tab, there exist an decimal number : 0.001 at
"Maximum Change" box, and
Integer number : 100 at "Maximum interation" box. But At computer that has
this error, I cannot view the "Caculation" Tab because it displays error :
Your entry cannot be used. An integer or decimal number may be required".;
therefore on this computer, I don't know whether this decimal number exists
as you said


"Dave Peterson" <ec35720@xxxxxxxxxxxxxxxxx> wrote in message
news:42CE6D35.58E56928@xxxxxxxxxxxxxxxxxxxx
> Take a look at Tools|Options|Calculation tab
>
> Do you have a decimal number in the "maximum change" box?
>
> If that's not it, what version of excel are you using? Maybe it'll help
others
> with suggestions.
>
> Huy Nguyen wrote:
> >
> > Dear all,
> >
> > Now, my Excel program has this error :
> > When I Click "Book1 WorkSheet" Document. And Choose "Tools"-> Options
on
> > the Menu. Then the "Options" Dialog appear, but I cannot click the mouse
to
> > move any Tab between "View", "Caculation", "Edit", "General",
> > "Transition"....tabs of this above dialog, and this following error
inform
> > "Your entry cannot be used. An integer or decimal number may be
required". I
> > removed Excel program and reinstalled Excel again, but this error still
> > happen.
> > How can I correct it? please reply to me as soon as possible. Thanks you
> > very much
>
> --
>
> Dave Peterson


.

Relevant Pages

  • Re: Importing multiple files..
    ... unless the .csv file has been opened by an Excel program and then saved ... Can u open the .csv file using ... Have you changed the import specification to use Tab as the field ... I tried even changing the extension to a *.txt and that did not ...
    (comp.databases.ms-access)
  • Re: about the error at Tools->Options of Excel
    ... Take a look at Tools|Options|Calculation tab ... Do you have a decimal number in the "maximum change" box? ... what version of excel are you using? ... > removed Excel program and reinstalled Excel again, ...
    (microsoft.public.excel)
  • Re: Changing Order in a table
    ... properties of the subform control (the "box" on the main form containing the ... Has the Data Entry property set to Yes ... click View>> Tab Order and set the Tab Order so that using the Tab ...
    (microsoft.public.access.forms)
  • Re: Windows cannot find ssttr.exe
    ... the entry, they like octopus with many testicles never end until ... Then click on Advanced tab and scroll down to under the Browsing Option: ... Lots of tools to download and disinfect your machine: ... be safely removed using Autoruns. ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Windows cannot find ssttr.exe
    ... entry left after the malware has been removed. ... Under General Tab clear your History, ... Lots of tools to download and disinfect your machine (offline ...
    (microsoft.public.windowsxp.perform_maintain)