Forum Discussion

ClaudiaR44's avatar
ClaudiaR44
Copper Contributor
Sep 21, 2023

paste with link option not available and circular reference error

Hello everybody,

I'm having trouble with a file where I have to copy and paste "with link" a certain amount of data from one sheet to another belonging to the same excel file. The problem is that the option of pasting with connection is not available and I cannot understand why. The area where I have to put the data is a table.. I tryed to undo the table format and any other formatting option in those cells but nothing changed. So I guess the real question here is: what are the conditions that make the "paste with link" option not suitable.

Another issue is that in that same file I had the problem of a circular reference inside some cells; I checked if the formula I put inside of them was "calling/referring" to herself, but it was not. So I'm wondering what could be the reasons behind a "circular reference" error.

Thank you to everyone who could give me a hand with this dummies problems !

  • ClaudiaR44 

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

    • ClaudiaR44's avatar
      ClaudiaR44
      Copper Contributor

      HansVogelaar Thank you for answering. Unfortunately I can't share the file for privacy. 
      About the paste with link problem, I can show you this screenshot ..I know it's not a lot; as you can see, when I right-click on the cell (which belongs to a table) where I want to paste the data, the icon with the paperclip is not showing and I don't understand why. I can't select it even if I click on Paste special. The data I'm trying to move there come from another table where the cells have formulas inside of them that take values from a third sheet.

      Instead, about the circular reference error, inexplicably it vanished today when I re-opened the file.

      ā€ƒ

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        ClaudiaR44 

        When I copy some cells and try to paste them into a table, the option to paste as a link is not available, as you mention.

        But if I convert the table back to an ordinary range, Paste Link is available:

        So I'm afraid I don't know why it doesn't work for you. Sorry!

Resources