Skip to main content
Participant
Nov 17, 2011 12:51 AM UTC
Answered

Data Merge error message

I keep receiving this message when selecting Data Source in InDesign: "The data source cannot be opened. Confirm that the file exists and that you have rights to open it, then choose the Select Data Source command again." I saved my excel file as a .csv file. What else needs to be done or isn't being done right?

Colin Flashman
Colin FlashmanCorrect answer
Community Expert
Oct 3, 2015 11:49 PM UTC

The answer was in the first reply to the post on this thread - this message (i've attached it below)

Can occur when the txt/csv file being opened is currently open somewhere else. Typically this is when it is still open in software such as Microsoft Excel. Close the software that may have that file open and try importing the data again.

If the answer wasn't in my post, perhaps it might be on my blog at colecandoo!

11 replies

Participant
Sep 1, 2024 10:23 PM UTC

Just close the file-Excel file that you need to import the data from, before importing the data, and it will work.

Translate
Participant
Oct 2, 2024 11:32 AM UTC

I'm still having a similar issue. Even when Excel is not open anymore I get the same error. Any other fixes?

Translate
Vivek-Sharma
Community Manager
Community Manager
Oct 2, 2024 12:00 PM UTC

Hi, Sorry for the trouble. Please try the steps suggested in this link and share the outcome.


^VS

Translate
Participant
Oct 1, 2015 9:28 AM UTC

I am also getting this exact same problem, were you able to find a way to fix it?

Translate
Colin Flashman
Community Expert
Colin FlashmanCommunity ExpertCorrect answer
Community Expert
Oct 3, 2015 11:49 PM UTC

The answer was in the first reply to the post on this thread - this message (i've attached it below)

Can occur when the txt/csv file being opened is currently open somewhere else. Typically this is when it is still open in software such as Microsoft Excel. Close the software that may have that file open and try importing the data again.

Translate
If the answer wasn't in my post, perhaps it might be on my blog at colecandoo!
Participant
Feb 15, 2016 1:47 AM UTC

So the error message should simple say "confirm the document is not open in another application" instead of this message. Typical Adobe -- no one is paying attention to details.

Translate
Peter Spier
Community Expert
Community Expert
Nov 17, 2011 1:02 AM UTC

make sure you've also closed it in Excel.

Translate
KPintaAuthor
Participant
Nov 17, 2011 2:01 AM UTC
Please download the attached file to view this post
Translate
Peter Spier
Community Expert
Community Expert
Nov 17, 2011 2:08 AM UTC

The text file would be more useful, but that looks OK...

Translate