Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling down formulas in a query table
Is there a way to get the formatting of the table headers NOT to copy down
with a calculated formula when a query updates? For example, I have a query that pulls some inventory data out of our Great Plains database. The query options are set to copy down formulas to the right of the data, and not to include field names. I added my own list of field names in the row above the query data, and formatted them with some borders and bold fonts. When I update the query, it copies the formatting down in the formula that exists to the right of the data, even though the format did not exist prior to the data refresh. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table formulas | Excel Discussion (Misc queries) | |||
Pivot table "Show all data" query | Excel Discussion (Misc queries) | |||
Formula Help | Excel Worksheet Functions | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
Capturing query table errors | Excel Worksheet Functions |