Forum Discussion

AandNSeaver's avatar
AandNSeaver
Copper Contributor
Apr 29, 2022

"Paste: Link" does not work in tables

Is there some way to enable the use of "paste link" inside tables?   I am creating a workbook to track contracts and invoices for multiple projects. The first tab is a master list of all the items ...
  • HansVogelaar's avatar
    May 01, 2022

    AandNSeaver 

    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.