Forum Discussion
"Paste: Link" does not work in tables
As you have found, Paste Link is not compatible with tables, so if you want to use the advantages of Paste Link, you'll have to convert your table to an ordinary range.
Alternatively, you could create a macro that formats selected cells the way you want. If you assign the macro to a Quick Access Toolbar button and/or a custom keyboard shortcut, you can easily run it.
As you have found, Paste Link is not compatible with tables, so if you want to use the advantages of Paste Link, you'll have to convert your table to an ordinary range.
Alternatively, you could create a macro that formats selected cells the way you want. If you assign the macro to a Quick Access Toolbar button and/or a custom keyboard shortcut, you can easily run it.
HansVogelaar Thank you for the information.
It is annoying that the “paste link” function does not work within a table. On the bright side, I took your advice and made a simple macro which works well. I had never made a macro so this was a good learning experience. Thank you for the advice.
- AandNSeaver Can you pls share the macro.
- BathindaHelper
Sorry, I do not have the macro any more. Shortly after creating a macro I found there were some flaws in it and I didn't have the drive to sort them out. This tracking sheet was not critical to my work and it was taking more time than I wanted to get it working so I abandoned it. Sorry I can't be of more help.
HansVogelaar Out of curiosity, do you know why it is incompatible? I'm not an Excel expert, but I'm struggling to think of a reason for this limitation.
I don't know why that is. Probably something technical.
