Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Tables / May 2008

Tip: Looking for answers? Try searching our database.

Error using Excel table created in Word 2007, in Word 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cee - 12 May 2008 21:27 GMT
I pasted a table created in Excel 2007 into Word 2007 using paste special >
paste as: Microsoft Office Excel 2003 Worksheet Object.  Both the original
Excel table and the Word doc were saved as "Word/Excel 97-2003" files.

When document is opened in client's Word 2003 program, the table reports a
"#NAME? " error in cells that provide results to calculations.  In case it
helps: example of  formula being used is
"=IF(ISBLANK(cellreference),"",EDATE(cellreference,3))"

Table works fine using my Word and Excel 2007 and all other elements of
table appear and work in client's 2003 document.

Is there something I can change to make this table compatible with Word 2003?

Thanks in advance for any suggestions you may have.
Bob   Buckland ?:-) - 15 May 2008 01:17 GMT
Hi Cee,

Is the reference to a named range?  There is a bug in Office 2003 Service Pack 3 that breaks the ability to link named ranges.
There is a hotfix that fixes that one, but it's not clear that you're seeing the same issue from your description.  Can you post a
link to a sample file set?

=============
I pasted a table created in Excel 2007 into Word 2007 using paste special >
paste as: Microsoft Office Excel 2003 Worksheet Object.  Both the original
Excel table and the Word doc were saved as "Word/Excel 97-2003" files.

When document is opened in client's Word 2003 program, the table reports a
"#NAME? " error in cells that provide results to calculations.  In case it
helps: example of  formula being used is
"=IF(ISBLANK(cellreference),"",EDATE(cellreference,3))"

Table works fine using my Word and Excel 2007 and all other elements of
table appear and work in client's 2003 document.

Is there something I can change to make this table compatible with Word 2003?

Thanks in advance for any suggestions you may have. >>
Signature


Bob  Buckland  ?:-)
MS Office System Products MVP

 *Courtesy is not expensive and can pay big dividends*

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.