I have a very large excel file with multiple tabs, hundreds of if statements,
some simple calculations, graphs and conditional formatting. Now when doing
data entry I get today’s date popping up in a cell that is not formatted and
when I go to print preview its not there.
Why is this happening?

Slow down a bit. You say "Now when doing data entry...". What are you
doing? Exactly? In what cell(s)? Don't just say you're entering data.
What data?
You say "I get today’s date popping up in a cell.." What cell? The active
cell? What sheet? The active sheet?
Give us a lot of detail No one here has any idea what you're doing. HTH
Otto

"Dana Stricker" <(E-Mail Removed)> wrote in message
news:01AEE697-1383-4DD3-A1F4-(E-Mail Removed)...
> I have a very large excel file with multiple tabs, hundreds of if
> statements,
> some simple calculations, graphs and conditional formatting. Now when
> doing
> data entry I get today’s date popping up in a cell that is not formatted
> and
> when I go to print preview its not there.
> Why is this happening?

"data entry" where?

Every cell, some cells, a specific cell?

Where does the date pop up?

Every cell, some cells, a specific cell?

After it pops up does it remain in the cell(s)?

Is it a cell value or an object?

Sounds like you have some event code running.


Gord Dibben MS Excel MVP

On Mon, 4 Jan 2010 10:32:02 -0800, Dana Stricker
<(E-Mail Removed)> wrote:

>I have a very large excel file with multiple tabs, hundreds of if statements,
>some simple calculations, graphs and conditional formatting. Now when doing
>data entry I get today’s date popping up in a cell that is not formatted and
>when I go to print preview its not there.
>Why is this happening?