The best way to do that is to leave the table in excel then insert it into the word document it will be like a picture in a word document but you can click on it and retain all the functions of excel in that one spot.
to do that correctly in word go to
file / insert object / excel work sheet
then select the excel sheet and the part of it that you want to use.
Is embedding Excel in Word the only option? My concerns are: (1) Will Word retain the protect function so that a user cannot expand the worksheet column, etc.?, (2) In my Excel sheet, cells requiring data are empty and an average formula appears below each section (five sections on the form require tallying, the remainder of the form is a text document), (3) the Word doument is protected by sections of the document- how does it react with an Excel spreadsheet embedded?
What other questions should I ask that I don't know to ask????
What is my next step?
At this point, I should wait for another support technician to reply? I do appreciate your help, but due to the nature of the users, I have to be absolutely sure that the end product works without issue. Thank you and I'll wait until I hear from someone for the answers to my questions.
The best time is now, but I assume that most people aren't working at 5:50 a.m. (EST)! I'm just nuts. However, if you are awake at this hour, please send me a message.
Are you available anytime between 8:30 - 10:00 a.m. (EST) today, Nov. 6th? My job generally pulls me away from my desk, but I will get your e-mail message on my phone so as soon as I get it, I'll get to my desk and contact you soon after.
I am at my desk now. I will keep the window open.
How do you want to receive it? Do you want the original copy of the document rather than the test documents I performed the cut and past from Excel but it doesn't seem to work - especially for users with little Excel experience.
There is no rush at the moment. Staff members are using the more difficult Excel file until I can finalize the Word document. Is this something you can help with by Friday of this week or do you need more time?