How to link correctly an excel file?

[Alex St-Pierre]

Does anyone know how to link correctly an excel file to a
merge without having to use office 97? I bought office xp
at work and I still use office 97 to make my merge because
with office 97, the merge file take the format of the
excel file.

A- With Office XP:
When I link an excel database to a word merge file, the
link is ok (I can change line) but:

1) The excel file doesn't open when I open the word file.
2) The merge doesn't take the format of the cell in the
excel sheet.

So, I have to enter all the format in the word file...

B- With Office 97:

1) The excel file open when I open the word file.
2) The word file takes all the format of the excel sheet.

So, I suppose that word takes the format of excel only if:
when I open the word file, the excel file open
automatically.

To be able to use office xp with a merge.. I must open the
merge with office97. Then, I set my database. So, the
excel file open everytimes the merge is open. I save and
now, if I open the merge with office xp, the excel file
will open and all the format is ok. And then, if I change
a format in excel and save the excel file, the format will
change in the merge. So, how can I set word 2002 to open
the link file everytime I open the word file (merge).

I think it's maybe a bug with office xp?? I would like to
know if there's any patch for that or a setting to click
somewhere..

Thanks,

Alex

 

[Alex St-Pierre]

That's ok..
Microsoft changes the way of doing merge.. now, we have to
put manually all the format except if your are going at
this adress!!
http://www.gmayor.com/formatting_word_fields.htm