Solved Combine 3 Separate Excel Files

January 15, 2020 at 06:40:54
Specs: Windows
I have 3 separate excel documents.

All documents have rows A -> AQ
Each document has over 1000 rows. Only 1 sheet.
Document location is:
\\[domain]\Users\[name]\Desktop\New folder\File 1
\\[domain]\Users\[name]\Desktop\New folder\File 2
\\[domain]\Users\[name]\Desktop\New folder\File 3


I need to combine these into 1 document and then sort rows based off of a column. The sort function is simple enough and can be done after the documents are combined.

The problem I have is that a simple copy/paste is not working. I'm not sure why this is. The documents are created as an exported report from an electronic medical record, so my initial thought is that this has something to do with the inability to copy/paste, but I am not sure.

What is the best way to combine these?

Thanks for any and all help with this.

message edited by Steven4321


See More: Combine 3 Separate Excel Files

Reply ↓  Report •

#1
January 15, 2020 at 07:13:36
✔ Best Answer
I figured this out. In the event that someone else has a similar issue, here is the super easy fix that can be tried.

Save the document as a .CSV file. Whatever "features" are lost in doing so will no longer prevent the copy/paste function.


Reply ↓  Report •

#2
January 15, 2020 at 08:06:31
Thanks for sharing this tip.

message edited by DerbyDad03


Reply ↓  Report •

#3
January 15, 2020 at 13:43:07
Just curious, did you notice if there were any macros?

Only way I know of to disable Copy / Paste is with a macro.

MIKE

http://www.skeptic.com/


Reply ↓  Report •

Related Solutions

#4
January 15, 2020 at 21:14:00
Put the 3 seperate files in a new folder
Open Excel
Go To Data Tab.
Click on Get Data.
Click on From File.
Click on From Folder.
Choose Folder With 3 seperate files
Click Combine and Edit
Click Close and Load
Save the combined excel AS as a new excel file

Reply ↓  Report •

#5
January 16, 2020 at 07:58:00
THEEXCELMASTER1979

What version of excel are you using?
My 2007 Excel does not have a simple Get Data in the Data Tab.

You aren't, perchance, using the Excel Add In Power Query?

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#6
January 16, 2020 at 10:07:54
Based on my 2016 version, "Click on Get Data" would need to be "Click on New Query". From there, the other steps are available.

In addition, in between "Click Combine and Edit" and "Click Close and Load" I think there needs to be a "Select the object to be extracted..." step. I had to select "Page 1" in order to make the OK button clickable.

Now, while that seemed to have worked for me with three very simple Excel files, I am also able to copy/paste, something that the OP says he can not do. Granted, he didn't say what actually happens when he tries to do a copy/paste, but his inability to do that may enter into this also.

Only one way to know: The OP should try the Combine method and see what happens.


message edited by DerbyDad03


Reply ↓  Report •

#7
January 19, 2020 at 02:16:53
Hi - The Icon says Excel 2016 but when I open it it says Excel 365. It is Microsoft office proplus 365 in programs bought by the company/ work computer!!

Reply ↓  Report •

#8
January 19, 2020 at 07:50:17
I think...(happens sometimes) that Excel 2016 is the earlier version of what's in 365...

http://tinyurl.com/s83r435

http://tinyurl.com/tgvy8af

http://tinyurl.com/tgvy8af

And there appear to be more than a few issues when Excel 2016 (as in Office 365) is used with the original/initial Excel 2016 source material/files?

https://jfw.groups.io/g/main/topic/...


Reply ↓  Report •

Ask Question