Forum Discussion

Copper Contributor

Jul 18, 2018

excel paste link - keep source formatting

Hi! I would like to draw together data from different workbooks by using pasta special - paste link, in order to ensure that the information is automatically updated in the compilation document s...

excel

Haytham Amairah

Silver Contributor

Jul 18, 2018

Hi Claire,

Try to reverse the steps you've done as follow:

First, paste it with the Keep Source Formatting option, and then paste it as links.

Regards

Nick PAPPAS
Copper Contributor
Jul 26, 2018
I would like to ask how we could keep the master data formatting and coloring after we update/create more data at master data file? ie if after copy paste link and keep formatting we write more data at master file i see data updated but if i color this line line at destination file is not colored also but only data
- Haytham Amairah
  Silver Contributor
  Jul 27, 2018
  Hi Nick PAPPAS,
  
  The only way to do this is to copy the data and paste it as Linked Picture as shown in the below screenshot:
  
  Regards
  - sdoyle
    Copper Contributor
    Jan 06, 2020
    Haytham Amairah
    Is there a restriction to what can be pasted as a linked picture. I can do so with one range I am working with, but not using another range. The one that works is actually more complicated (including hidden rows and comlumns), than the one that the "Linked Picture" option does not appear when I right click....