A quick look doesn't show anything about any kind of Ribbon Data tabs or Queries and Connections. I'll try and see if I can find it by searching on the internet for it on Excel 2013.




OK, did a search and made sure my show tabs is turned on which it is but where would those tabs be, I don't see any?

Did you forget to write something in your last post?


Did you forget to write something in your last post?


Here's a new copy of my Games-Name file I made. Are those txt/queries in it also?

Attached Files

GAMES-Name.xlsm (174.3 KB, 8 views)

No, it was just to help you find things.

No, there are none of those.

It didn't help much, never did find anything.

I think I found the queries & connections, is this it?

Attached Images

Qs and connect.jpg (29.5 KB, 25 views)

Yes. I did say:The file you attached to msg#48 is clear of all that.
The file you attached to msg#16 has plenty of all that.

OK, I took a look at it and seen the connections but I don't understand what it's for, how they got there or why it's not good. Could you explain please so I don't do whatever I did to get these?

You just need to delete the queries after you've done the importing.

I didn't do any kind of importing of data though. What I did was copy and pasted the text from a list I had gotten from the Commodore computer unless you call copy and pasting text importing?
I will not be doing any more of that anyway since I got everything I needed from the Commodore so I am probably good to go with the newest files I have made.....Right?

Sounds good!

Here is the latest file that just stopped working while I was editing it. Don't know what happened. I started adding to the file around entry 2695 or so and as I was adding, it would put it in the Print Me sheet but then it stopped doing that at line #2887 in the Edit Me sheet in respect to Line #700 in the Print Me sheet.

Attached Files

GAMES-ID.xlsm (177.8 KB, 9 views)

I opened your file, ran the macro and it's fine?!

Maybe I'm doing something wrong then. What I'm doing is opening up the file, bring up the EditMe sheet and start entering data which in turn should put it over into the PrintMe sheet. Do I need to do something before I start entering data? I know I looked in the Macro section and it was there...Oh wait, I didn't hit run, now it's working again. Nevermind, my brain just isn't working.....Again!

The macro puts links into the PrintMe sheet in gobs of a printed page at a time (200 entries).
You'd just reached a point where you needed another page, so it needed a re-run of the macro.