Hi
Sorry, not the best title to the post but my problem is that occasionally I seem to do something to an Excel file which causes it to list an earlier copy of a sheet when I try to connect to it as a data source from Word. Not sure what, but last time it seemed to happen as a result of putting in a few extra columns created by VBA macro.
A picture should help (see attachment) - when opening the Excel file I can just see a single sheet called 'UK' with my addresses in it. When looking at it as a datasource I get the attached list of 2. One of these is an earlier version of the data.
Other times I just get the one table name to choose from.
Can someone tell me what's going on? - I need to send sheets to colleagues to use as data sources and don't want them picking the wrong one. As this seems to happen after I've inserted a few columns into the sheet, they could get the earlier version and end up with problems. Is there a way of removing the older version?
To make things even more annoying, I'm struggling to re-create the problem. It just happens sometimes!
Thanks!
