|
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 08:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com