• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

What to Do If You Cannot Link Cells from an Excel Worksheet

Make sure you've actually saved the Excel worksheet; if the worksheet doesn't have a filename yet, the link won't work properly. Once you've done so, create the link again, specifying the filename you just created.

What to Do If You Can't Open a Worksheet in Excel After You Edit and Save It in Word

Word enables you to open an Excel worksheet directly, by choosing it in the Open dialog box and clicking Open. If you do this, the cells are placed in your document in the form of a Word table. Because Word cannot save in Excel format, when you resave the file, it is converted to a Word file, and Excel cannot read it. If you've made changes, you can copy them manually into Excel, though you'll have to reformat them. If you need to make changes that will be readable in Excel, use the techniques described elsewhere in this chapter to create a link to an Excel document, rather than opening it directly.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint