I need your help please on these two questions:
Thanks in advance,
As you may have noticed, each send of FC simply deletes the sheet and re-inserts it. So, the direct answer to your question is "no"
However, most customers work in a different way with DM
They use 2 Excel (files or sheets, you can achieve it either way). The one is simply the "raw" data and this comes from FC, or BPC (via EPM add-in report) or via BeX query (BW connector in DM)
Then, you have another Excel and define a data-link (option Manage Datalink). This is a link from Excel to Excel.
Note: you could also do this natively in Excel (with =VLOOKUP formulas)
On this new file/sheet you define your formatting, add extra columns, formulas (averages etc.) and this forms the basis for the objects you link in the Word document.
I hope this helps!