Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problems with Excel97 version
Hi,
I some customers that I've created spreadsheets as an Excel97 version. When the customers attempt their Mail Merge using Word 2003, it gives an error. When we open those Excel files in Excel2003, resave, and then attempt the Mail Merge in Word 2003, it works. Unfortunately the software I use to create the Excel files has Excel97 as the latest version. When we attempt to save them as Excel95 or earlier, other problems occur. These files do contain fields with date & currency formatting, which I've read may cause some problems. Any help would be appreciated. Thanks! Matt |
#2
|
|||
|
|||
The exact error I am getting is : "This data source contains no visible
tables". "cmb" wrote: Hi, I some customers that I've created spreadsheets as an Excel97 version. When the customers attempt their Mail Merge using Word 2003, it gives an error. When we open those Excel files in Excel2003, resave, and then attempt the Mail Merge in Word 2003, it works. Unfortunately the software I use to create the Excel files has Excel97 as the latest version. When we attempt to save them as Excel95 or earlier, other problems occur. These files do contain fields with date & currency formatting, which I've read may cause some problems. Any help would be appreciated. Thanks! Matt |
#3
|
|||
|
|||
Hi ?B?Y21i?=,
I some customers that I've created spreadsheets as an Excel97 version. When the customers attempt their Mail Merge using Word 2003, it gives an error. When we open those Excel files in Excel2003, resave, and then attempt the Mail Merge in Word 2003, it works. Unfortunately the software I use to create the Excel files has Excel97 as the latest version. When we attempt to save them as Excel95 or earlier, other problems occur. These files do contain fields with date & currency formatting, which I've read may cause some problems. Have you tried marking the data areas with RANGE NAMES? Other than that, the only other thing I can imagine would be to save in delimeted text format, rather than in Excel format. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrong Version on latest MS05-023 Word2k3 version | Microsoft Word Help | |||
Will Word 2003 Trial version documents be available to earlier ve. | Microsoft Word Help | |||
Add way to show document version in autotext | Microsoft Word Help | |||
Word 2000 is version 9 Is there any newer version ? | Microsoft Word Help | |||
File Corruption problems | Page Layout |