Technology Questions

Go Back   Technology Questions > Software Questions > General Questions > Microsoft Office

Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old 12-14-2007, 08:40 PM
BillT853210
Newsgroup Contributor
 
Posts: n/a
Can't modify Excel file after Word Mail Merge

I created a file in Excel, then did a Mail Merge from Word using that
Excel file as the data source. I later tried to modify the Excel file but
when attempting to save it, got alert "<file.xls> is locked for editing ... "
even though Word had been closed. My workaround is to do a save-as
<file2.xls> then delete <file.xls> and rename the saved-as file to <file.xls>.
Does the Dynamic Data Exchange force this or is there a way to modify
a data source file and reuse it? Only the data fields are modified not the
header record.

I must be doing something wrong but don't know what it is. Any ideas?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

 
Old 12-14-2007, 08:40 PM
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening Word or Excel file from file shortcut opens Word or Excel program, but not the file betel11geuse@gmail.com Microsoft Office 1 10-01-2007 06:40 AM
Mail merge Excel to Word Jim Microsoft Office 1 07-20-2007 03:51 AM
Word, Excel, Outlook Mail Email Merge Michelle King Microsoft Office 0 05-31-2007 11:20 AM
Excel E-mail/Mail Merge Question JDenise Microsoft Office 0 03-13-2007 07:46 AM
VB and Mail Merge Excel/Word mr starface Microsoft Office 2 01-15-2007 11:55 AM


New To Technology Questions? Do You Need Help with Your Computer or Device? Do You Need Help with this site?

All times are GMT -8. The time now is 12:55 PM.


2003 - 2009 All Rights Reserved. Technology Questions

Search Engine Friendly URLs by vBSEO 3.3.0