| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EDATE Problem
It was working fine yesterday and I come in today to update certain things and it will not work. When I change the date in the cell that would normally effect the formulated cell, the formulated cell value does not change. If I select the formulated cell and hit F2, enter, it will change but it used to do it automatically. I have the the analysis toolpak checked and there have not been any changes to the system. -- pknivens ------------------------------------------------------------------------ pknivens's Profile: http://www.excelforum.com/member.php...o&userid=27675 View this thread: http://www.excelforum.com/showthread...hreadid=492107 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EDATE Problem
ToolsOptionsCalculation, check Automatic
-- Kind regards, Niek Otten "pknivens" wrote in message ... It was working fine yesterday and I come in today to update certain things and it will not work. When I change the date in the cell that would normally effect the formulated cell, the formulated cell value does not change. If I select the formulated cell and hit F2, enter, it will change but it used to do it automatically. I have the the analysis toolpak checked and there have not been any changes to the system. -- pknivens ------------------------------------------------------------------------ pknivens's Profile: http://www.excelforum.com/member.php...o&userid=27675 View this thread: http://www.excelforum.com/showthread...hreadid=492107 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EDATE Problem
Thank you that worked, but how would something like that change by itself. -- pknivens ------------------------------------------------------------------------ pknivens's Profile: http://www.excelforum.com/member.php...o&userid=27675 View this thread: http://www.excelforum.com/showthread...hreadid=492107 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EDATE Problem
You probably had another workbook loaded in which this was set. It is a
setting which applies to all open workbooks. -- Kind regards, Niek Otten "pknivens" wrote in message ... Thank you that worked, but how would something like that change by itself. -- pknivens ------------------------------------------------------------------------ pknivens's Profile: http://www.excelforum.com/member.php...o&userid=27675 View this thread: http://www.excelforum.com/showthread...hreadid=492107 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EDATE Problem
Well either way thanks alot. now i know to keep an eye on that. -- pknivens ------------------------------------------------------------------------ pknivens's Profile: http://www.excelforum.com/member.php...o&userid=27675 View this thread: http://www.excelforum.com/showthread...hreadid=492107 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| problem office assistant | Excel Discussion (Misc queries) | |||
| EDATE &EOMONTH problem | Excel Worksheet Functions | |||
| Edate problem | Excel Worksheet Functions | |||
Hybrid Mode
