K
Kevlar
Norman said:
Well.....I reset my security to Low to enable macros in safe mode an
this is when it happened. Hummmm.......sounds like I have somethin
firing in the background
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Well.....I reset my security to Low to enable macros in safe mode an
this is when it happened. Hummmm.......sounds like I have somethin
firing in the background
D
Dave Peterson
Skip to the bottom portion (my real guess).
When you start in safe mode, I don't think any macros will run.
Are you sure you were in safe mode?
If you're positive it's not in the code in that workbook (make sure you look
under ThisWorkbook and the worksheet with the problem), then it might be a
workbook that does some special stuff (application events that can look across
any workbook).
Chip Pearson has some notes on application events at:
http://www.cpearson.com/excel/AppEvent.htm
And some notes about "normal" events at:
http://www.cpearson.com/excel/events.htm
But even better he has some notes on how to find startup errors (and it sounds
like you need to isolate what loads when you startup excel) at:
http://www.cpearson.com/excel/StartupErrors.htm
Essentially, you're going to move stuff out of your XLStart folder and uncheck
everything under Tools|Addins. (But keep track!)
Then one by one, you'll add one back and restart excel to see if that caused the
problem.
===============
I just reread your post about pasting causing the trouble (sometimes).
My revised guess is that you're copying non-contiguous rows (like 2,6,18) from a
filtered range to a brand new worksheet.
Excel will convert those formulas to values.
If the rows are all contiguous, then you'll get the formulas.
I'm putting my money on this one! Don't tell me I'm wrong.
When you start in safe mode, I don't think any macros will run.
Are you sure you were in safe mode?
If you're positive it's not in the code in that workbook (make sure you look
under ThisWorkbook and the worksheet with the problem), then it might be a
workbook that does some special stuff (application events that can look across
any workbook).
Chip Pearson has some notes on application events at:
http://www.cpearson.com/excel/AppEvent.htm
And some notes about "normal" events at:
http://www.cpearson.com/excel/events.htm
But even better he has some notes on how to find startup errors (and it sounds
like you need to isolate what loads when you startup excel) at:
http://www.cpearson.com/excel/StartupErrors.htm
Essentially, you're going to move stuff out of your XLStart folder and uncheck
everything under Tools|Addins. (But keep track!)
Then one by one, you'll add one back and restart excel to see if that caused the
problem.
===============
I just reread your post about pasting causing the trouble (sometimes).
My revised guess is that you're copying non-contiguous rows (like 2,6,18) from a
filtered range to a brand new worksheet.
Excel will convert those formulas to values.
If the rows are all contiguous, then you'll get the formulas.
I'm putting my money on this one! Don't tell me I'm wrong.
U
uteitler
I had exactly the same issues and have tried everything.
Here are a few things I noticed:
1) The cell where the formula was being replaced had a name defined
2) It had formatting (color and alignment)
Even when I got rid of that I still had the issue ..
In the end, I simply deleted the whole column, inserted a new colum
and have never had the problem since
Here are a few things I noticed:
1) The cell where the formula was being replaced had a name defined
2) It had formatting (color and alignment)
Even when I got rid of that I still had the issue ..
In the end, I simply deleted the whole column, inserted a new colum
and have never had the problem since
K
Kevlar
uteitler said:*
In the end, I simply deleted the whole column, inserted a new colum
and have never had the problem since. *
That is exactly what I did. Thanks for the reply