Merging Filtered Excel Data

[LFP]

Hello;
Can I select an Excel spreadsheet that has filters turned on for my
datasource in a merge document? It seems to still want to merge all data,
not just filtered.

TIA

 

[Peter Jamieson]

I do not think Word will honour the filters you applied in Excel, i.e.
you should either consider making a new sheet that contains only th
filtered data, or re-filter the data in Word (which does not have very
good facilities for that). Word can also have difficulty connecting to
data that has been grouped/filtered, but I do not know exactly what it
objects to.


Peter Jamieson

http://tips.pjmsn.me.uk