Quote:
Originally Posted by dylansmith
not the most ideal option if they are highly relevant to one another
...
it would look like a poorly formatted sheet in others' opinion..
|
Please don't shoot the messenger - I'm merely telling you what your options are. It's up to you to choose what course you take.
Quote:
is it possible to have a dynamic link between Excel & Word. for example, when we put an Excel file within powerpoint, the excel file can be edited directly and source file is updated accordingly. there doesn't seem to be a similar function in Word?
|
You can both link the content and update it from Word. To link, choose Paste Special with the link option and the link format of your choice. To edit, simply right-click on the linked data, then choose Linked Worksheet Object> Edit (or Open) to open the workbook for editing.
It's not clear what your issue is with 'Convert to Range'. If you want the Sub-Total, Tax & Grand Total cells shaded, simply copy & paste the formats from the rows above to just those cells, or include those entire rows in the table beforehand.