|
|
Thread Tools | Display Modes |
#1
|
||||
|
||||
Excel seems to create copies of tables visible only when used as a data source
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! |
#2
|
||||
|
||||
Hmmm - looks like this cause by Autosave.
I'll try turning this off and see how it goes. |
#3
|
||||
|
||||
OK, autosave disable did not seem to help.
Anyone got any other ideas? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel data linked to external source | Doug Needham | Excel Programming | 1 | 09-15-2015 05:14 AM |
Merge fields in Word and source data from Excel | SteveVai | Mail Merge | 3 | 03-13-2014 05:25 AM |
Create DDL from Excel source | BradleyS | Word | 1 | 01-30-2013 10:58 PM |
How can I revise Excel data source in merge? | navysalad | Mail Merge | 6 | 01-07-2012 06:50 PM |
How to create an Excel add in that will automatically build tables from data | selvamariappan | Excel Programming | 1 | 12-12-2011 03:11 AM |