View Single Post
 
Old 08-12-2018, 09:38 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by thumb View Post
As for those Games1.txt, where are they in the workbook? I know what they are, it was when I was converting text files from an old Commodore computer over to the PC but I only used the text to copy and paste...or at least I thought.
You're using Excel 2013 so I'm not sure it'll look the same as mine, but if you go to the Ribbon Data tab, in the Queries and Connections section there's a Queries and Connections button, if you click it it should show you a whole raft of connections. If you right-click on one, there should be the option to delete it. There's also a bunch of related Names; if you go to the Formulas tab of the ribbon, and choose Name Manager, you'll see those Names (you can delete them easily here). You can visualise where they are on the sheet by zooming out to 30% or less (bottom right of the window usually) and they should appear highlighted.
Reply With Quote