Date functions in Excel 2007 tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rövitt - 23 May 2008 11:06 GMT

How can I use the various date functions in an Excel table generated by MS
query, without having to convert the table to a range, thereby losing the
query definition ?

Reply to this Message

ShaneDevenshire - 25 May 2008 20:23 GMT

Hi,

You can place any calculated field in columns directly adjacent to the
connected table range and then you can have Excel fill those formulas down
automatically everytime you refresh your data.
1. Create a formula in the column direcly adjactent to the table.
2. Click in the table range and choose the command Data, Import External
Data, Data Range Properties. Turn on the bottom checkbox - Fill down
formulas in columns adjacent to data.

Hope this helps.

Signature

Cheers,
Shane Devenshire
Microsoft Excel MVP

> How can I use the various date functions in an Excel table generated by MS
> query, without having to convert the table to a range, thereby losing the
> query definition ?

Reply to this Message