Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Rayashe Rayashe is offline
external usenet poster
 
Posts: 10
Default Word not allowing 2 documents to access data source at same time

Previously I have been able to open up 2 separate documents at the same time
that take their data from a common Excel file.

As of this week I get a pop-up that says:
This file is in use.
Enter a new name or close the file that's open in another program.

I am using Windows 7 and Office 2007.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Word not allowing 2 documents to access data source at same time

If your Excel workbook is a .xlsx or .xlsm (i.e. an Excel 2007 format
workbook) then Word will not be able to open it as a data source in two
separate mailmerge documents. If it is an old-style .xls Word will
/probably/ be able to do that (I can't check the Win 7/Word 2007
combination specifically), although if the .xls is located on a network
drive, that might make a difference.

I don't know exactly why this should be so, but I suspect that whatever
code library Microsoft uses in its ACE OLE DB provider to open .xlsx
(and Office 2007 format documents in general) locks the .xlsx in some
way that the older Jet provider did not do.

There might be a workaround but I am not currently aware of one.

Peter Jamieson

http://tips.pjmsn.me.uk

On 22/01/2010 10:14, Rayashe wrote:
Previously I have been able to open up 2 separate documents at the same time
that take their data from a common Excel file.

As of this week I get a pop-up that says:
This file is in use.
Enter a new name or close the file that's open in another program.

I am using Windows 7 and Office 2007.

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Rayashe Rayashe is offline
external usenet poster
 
Posts: 10
Default Word not allowing 2 documents to access data source at same ti

Hi Peter,
The Windows 7 & .xls combination seems to work - thanks

It is odd though as the Windows 7 & Office 2007 combination WAS/HAS been
working since I installed Win7 at the start of December???

"Peter Jamieson" wrote:

If your Excel workbook is a .xlsx or .xlsm (i.e. an Excel 2007 format
workbook) then Word will not be able to open it as a data source in two
separate mailmerge documents. If it is an old-style .xls Word will
/probably/ be able to do that (I can't check the Win 7/Word 2007
combination specifically), although if the .xls is located on a network
drive, that might make a difference.

I don't know exactly why this should be so, but I suspect that whatever
code library Microsoft uses in its ACE OLE DB provider to open .xlsx
(and Office 2007 format documents in general) locks the .xlsx in some
way that the older Jet provider did not do.

There might be a workaround but I am not currently aware of one.

Peter Jamieson

http://tips.pjmsn.me.uk

On 22/01/2010 10:14, Rayashe wrote:
Previously I have been able to open up 2 separate documents at the same time
that take their data from a common Excel file.

As of this week I get a pop-up that says:
This file is in use.
Enter a new name or close the file that's open in another program.

I am using Windows 7 and Office 2007.

.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Source Lost When Merge From Access to Word Sarah G Mailmerge 12 October 24th 07 10:23 PM
Data Source Lost When Merge From Access to Word Sarah G Mailmerge 0 September 18th 07 10:26 PM
Word 2000 mail merge documents won't save Access 2000 data source Andy C Mailmerge 1 May 17th 06 08:39 AM
Allowing hyperlink Access to Protected documents Premier_Rep Microsoft Word Help 1 May 2nd 06 06:30 PM
Using Access Data Source for Word Documents Sharon Mailmerge 0 August 24th 05 10:56 AM


All times are GMT +1. The time now is 02:00 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"