Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SQL - Auto Refresh Upon Cell Value Change
Hi Readers,
Could anyone please help with an annoying obstacle I have enountered? I am using the 'Refresh automatically when cell value changes' option for MS-Query criteria. My criteria cell is a date, in the format: 2005-05-31. I have sussed all the formatting issues, but my problem is this: My criteria cell is actually the result of a formula used to calculate the end of the month, from another cell containing the month I'm looking at. The criteria cell formula is as follows: =TEXT(DATE(YEAR(TODAY()),D21+1,0),"YYYY"&"-"&"MM"&"-"&"DD") The problem is, that when the month cell is updated, my criteria cell formula then recalculates my new 'end month date' but my SQL report (on another worksheet) doesn't refresh. I have found that directly typing in my new 'end month date' forces the refresh, so I believe the problem is as follows: The 'auto refresh' function only 'watches' the formula, which of course remains static, and not the 'value' of the cell which IS changing. Does anyone know a way around this at all? I know this could be done using VBA, but I'd much prefer not to employ its use, if possible, for reasons not worth boring you all with :o) I am sincerely grateful for any comments or suggestions anyone may have. Thanks! Elliot |
#2
|
|||
|
|||
Anyone?
Surely the answer's not *that* obvious?! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change color of active cell in Excel | Excel Discussion (Misc queries) | |||
background color of my cell does not change | Excel Discussion (Misc queries) | |||
Set default in auto fill options, I always want to copy cell, som. | Excel Discussion (Misc queries) | |||
Cell color change in formula | Excel Worksheet Functions | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) |