Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formulas appearing in empty cells when they shouldn't
I have a worksheet with many formulas for different cells based on the hour
of day. (S1-S8 for 0100-0800, T9-T12 for 0900-1200, U13-U1800 for 1300-1800, T19-T23 for 1900-2300, S24 for 2400). The problem is that the formulas are only input in the cells listed but in the empty cells adjacent to cells with formulas the formula will input itself when the data is input in the cell the formula above or beside it is looking at/for. (T13 should be empty and is left blank when worksheet created but when the data that U13 is looking at is input it seems like T13 is copying the formula from T12 all by itself) I have already remove the "allow data ranges to extend" selection in the excel options area, I thought that worked but other users are still having the problem. I checked their settings and they are the same as mine. Any ideas? Please help! Sorry, I tried to describe as best and clearly as I could! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formulas appearing in empty cells when they shouldn't
I suspect a macro is running that may be causing a problem. first make sure
both PC's have the security setting set to medium. menu Tools - Macro - Security - Medium Then restart excel and check to see if the pop up window asks to Enable/Disable macros. This will tell you if there are macros running Select "DISABLED" macros on both PCs and see if the problem is still occuring. "Paolo" wrote: I have a worksheet with many formulas for different cells based on the hour of day. (S1-S8 for 0100-0800, T9-T12 for 0900-1200, U13-U1800 for 1300-1800, T19-T23 for 1900-2300, S24 for 2400). The problem is that the formulas are only input in the cells listed but in the empty cells adjacent to cells with formulas the formula will input itself when the data is input in the cell the formula above or beside it is looking at/for. (T13 should be empty and is left blank when worksheet created but when the data that U13 is looking at is input it seems like T13 is copying the formula from T12 all by itself) I have already remove the "allow data ranges to extend" selection in the excel options area, I thought that worked but other users are still having the problem. I checked their settings and they are the same as mine. Any ideas? Please help! Sorry, I tried to describe as best and clearly as I could! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formulas appearing in empty cells when they shouldn't
Seems to have worked! There are 8 different people who use these worksheets
and all on different shifts, so I will have to see if a few more people see this correction to know for sure. Thanks for your help!!!!!!! The sheet was saved as a excel workbook and not a macro enable worksheet, I thought this would disable the macro used to create the workbook but maybe not. Thanks again for all the info! "Joel" wrote: I suspect a macro is running that may be causing a problem. first make sure both PC's have the security setting set to medium. menu Tools - Macro - Security - Medium Then restart excel and check to see if the pop up window asks to Enable/Disable macros. This will tell you if there are macros running Select "DISABLED" macros on both PCs and see if the problem is still occuring. "Paolo" wrote: I have a worksheet with many formulas for different cells based on the hour of day. (S1-S8 for 0100-0800, T9-T12 for 0900-1200, U13-U1800 for 1300-1800, T19-T23 for 1900-2300, S24 for 2400). The problem is that the formulas are only input in the cells listed but in the empty cells adjacent to cells with formulas the formula will input itself when the data is input in the cell the formula above or beside it is looking at/for. (T13 should be empty and is left blank when worksheet created but when the data that U13 is looking at is input it seems like T13 is copying the formula from T12 all by itself) I have already remove the "allow data ranges to extend" selection in the excel options area, I thought that worked but other users are still having the problem. I checked their settings and they are the same as mine. Any ideas? Please help! Sorry, I tried to describe as best and clearly as I could! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas that may sometimes contain empty cells | Excel Worksheet Functions | |||
formulas showing up in empty cells all by themselves | Excel Programming | |||
FORMULAS IN CELLS APPEARING AS TEXT IN THE CELL | Excel Discussion (Misc queries) | |||
0's appearing in chart, even when cell is empty | Charts and Charting in Excel | |||
Excel: How to stop '#div/0!' from appearing in empty cells. | Excel Discussion (Misc queries) |