ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula in cell !!! (https://www.excelbanter.com/excel-discussion-misc-queries/215734-formula-cell.html)

[email protected]

Formula in cell !!!
 
I keep getting an annoying alert "Formula in cell !!!" even when the cell is
empty. Any ideas on why and how I can stop these false alerts occuring?

Shane Devenshire[_2_]

Formula in cell !!!
 
Hi,

Where exactly are you seeing this message -
- a dialog box?
- in a cell?
- on the status bar?

Does this occur in all workbooks, one workbook or only some sheet(s) in a
workbook?

It sounds like you have a VBA macro running.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


" wrote:

I keep getting an annoying alert "Formula in cell !!!" even when the cell is
empty. Any ideas on why and how I can stop these false alerts occuring?


[email protected]

Formula in cell !!!
 
Thx Shane

The message appears in what looks like a text box. It disappears when I
select some other cell (or more likely the first message disappears and a
new identical one appears).

It appears randomly on different worksheets in different workbooks. It may
or may not appear when there actually is a formula in the cell!

I don't intentionally have any macro's running.

"Shane Devenshire" wrote:

Hi,

Where exactly are you seeing this message -
- a dialog box?
- in a cell?
- on the status bar?

Does this occur in all workbooks, one workbook or only some sheet(s) in a
workbook?

It sounds like you have a VBA macro running.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


" wrote:

I keep getting an annoying alert "Formula in cell !!!" even when the cell is
empty. Any ideas on why and how I can stop these false alerts occuring?



All times are GMT +1. The time now is 02:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com