I tried changing the options, but nothing changed when I went to use the document as the source. I think I explained it poorly. I've attached a slightly edited version of the document I'm working on that I'm trying to use as a data source.
When I say the formatting table, I really just mean a regular table made in Word. I was trying to differentiate between that and an Excel table. You'll see in the document. The entire top half is the Header and then the table is the majority of the content, but it doesn't recognize the table as a valid data source anymore, probably caused by the move away from a DDE connection like you said.
I tried embedding an Excel table into the document (they want it to be word because they also print this sheet out for a paper trail, which is it's own debate), but it made the data entry more difficult because they would have to double click on the table to get into the excel document and enter it from there and it's not as restrictive as the word table which is locked at 4 columns and 5 rows.
Thank you for your reply! I'm looking through your blog now, it seems very helpful.
Last edited by nchandler; 05-01-2015 at 02:43 PM.
Reason: Added the attachment
|