Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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: 72
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, 14 views)
Reply With Quote
  #2  
Old 01-11-2018, 09:57 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: 72
catflap is on a distinguished road
Default

Hmmm - looks like this cause by Autosave.

I'll try turning this off and see how it goes.
Reply With Quote
  #3  
Old 01-17-2018, 08:04 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: 72
catflap is on a distinguished road
Default

OK, autosave disable did not seem to help.

Anyone got any other ideas?
Reply With Quote
Reply

Thread Tools
Display Modes


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 04:25 PM.


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