I have a Pivot Table worksheet in Excel 2007 that's running off a SQL command. The dates in this statement are hardcoded at the moment: I'd like to link them into a couple of cells in the sheet, but Excel is being more unhelpful than usual.
There's a greyed-out Parameters button at the bottom of the Connection Properties: Definition tab, but no particular mention of how to get it to actually work. I tried putting ?DateFrom and ?DateTo into the SQL: it correctly recognized those as missing parameters (and gave me no option to supply them), so I tried ?=B1 and ?=B2 instead: no dice either. Help me save what little hair I have left, please. :-) _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.