Hi Paul,
I have made a discovery about this Word problem.
So that you can experience it exactly as I am I have attached an Excel and Word file that I was using to hunt down the problem.
If you open the Excel file first and then the Word file, you will notice that the Word file shows all of the inserted Excel worksheet AND that there is a message to the effect that there may be linked files and would you like to update them... should you click Yes then the displayed worksheet will truncate to only a few columns and rows of the whole Excel worksheet.
However, if you open the Word file first you will notice that the Word file shows all of the inserted Excel worksheet AND that there is a message to the effect that there may be linked files and would you like to update them... should you click Yes then then the displayed worksheet will refresh in its entirety.
You can then open the Excel file and edit it as you wish. If you then go back to the Word file and right hand click anywhere in the Excel inserted material the resulting drop down menu has an option to 'Update Link' - if you click on this the data will update BUT the displayed material will truncate to only a few columns wide by a few rows deep. If you then close both the Excel and Word file (you'll be prompted to save the Word file) and then reopen ONLY the Word file the truncated Excel material will be displayed and you'll get the message asking if you want to update the linked material - clicking Yes will cause the info to update AND the full linked material to display.
As I noted - early on I could edit the Excel and then update the Word over and over and the Word would keep updating and keep displaying the entire Excel linked material.
Perhaps from this discovery you can spot the problem.
Before I post this - To any others reading this post who are trying to insert Excel worksheets in Word I have also noted the following - if, when linking the worksheet, the worksheet you want to link is not the one you want (in my experience it will keep inserting the first tab of the workbook, open the tab (worksheet) you want to link, highlight the area you want to link then save and close the workbook. Then reopen the worksheet and on the Word file re-insert the worksheet that you wanted and it should work.
Regards,
Jon.
|