Formulas not working

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nigel - 26 Sep 2007 18:42 GMT

I have a spreadsheet and am running so code across the sheet, all of a sudden
instead of applying the code it is now just putting the formulas in the
cells, I know a setting has changed somewhere but I can't find it

Any suggestions

THanks

Reply to this Message

JW - 26 Sep 2007 18:51 GMT

Try Ctrl+` (which is the tilde key next to the #1 at the top). That
key combination toggles your view from formulas to values.

> I have a spreadsheet and am running so code across the sheet, all of a sudden
> instead of applying the code it is now just putting the formulas in the
[quoted text clipped - 3 lines]
>
> THanks

Reply to this Message

Tom Ogilvy - 26 Sep 2007 18:54 GMT

If no formulas are working, then go to Tools=>Options, and under view,
uncheck Formulas down toward the bottom section.

You can also toggle that view with Ctrl+ the key on the left of the number
row - tilde for me in the US, but it differs based on regional keyboard.

Otherwise, if some formulas are working and some are just displayed, make
sure the cells with the displayed formulas are not formatted as text (or
don't refer to cells formatted as text) and don't have a space in front of
the equal sign.

Signature

regards,
Tom Ogilvy

> I have a spreadsheet and am running so code across the sheet, all of a sudden
> instead of applying the code it is now just putting the formulas in the
[quoted text clipped - 3 lines]
>
> THanks

Reply to this Message

Nigel - 26 Sep 2007 19:20 GMT

Tom you hit it on the head, the data was coming from a showcase query and
the cells where the formulas where being entered were marked as text, changed
whole spreadsheet to general and everything was perfect

thanks

> If no formulas are working, then go to Tools=>Options, and under view,
> uncheck Formulas down toward the bottom section.
[quoted text clipped - 14 lines]
> >
> > THanks

Reply to this Message