Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-09-2018, 10:00 AM
catflap's Avatar
catflap catflap is offline Excel seems to create copies of tables visible only when used as a data source Windows 7 64bit Excel seems to create copies of tables visible only when used as a data source Office 2013
Advanced Beginner
Excel seems to create copies of tables visible only when used as a data source
 
Join Date: Aug 2015
Location: UK
Posts: 77
catflap is on a distinguished road
Default 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!
Attached Images
File Type: jpg 2 data sources.jpg (60.6 KB, 16 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel seems to create copies of tables visible only when used as a data source 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
Excel seems to create copies of tables visible only when used as a data source Create DDL from Excel source BradleyS Word 1 01-30-2013 10:58 PM
Excel seems to create copies of tables visible only when used as a data source How can I revise Excel data source in merge? navysalad Mail Merge 6 01-07-2012 06:50 PM
Excel seems to create copies of tables visible only when used as a data source How to create an Excel add in that will automatically build tables from data selvamariappan Excel Programming 1 12-12-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft