Power Query Table not allowing copy & paste

taylorg1820

New Member
Joined
Jun 2, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I needed to use Power Query to reformat data into a table I can use for analysis. I wanted to add a column where I could type comments, which are typically pasted from a different source. For whatever reason, excel is not allowing me to paste anywhere in the power query table. I can paste anywhere in the sheet outside of the table, but as soon as I click in the table, the paste button is greyed out. Is there a way to do this? My end goal is to create self referencing tables so that I can manually add comments which are logically linked to the rows of data in the table (so when I sort the table the comments are still in the correct rows). How can I do this while still being able to use copy and paste?
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Seems it is not a general issue...
1654446206481.png

You can add an extra "comment" column. When you create the self reference, that "new" column is also kept.
The technique was explained here.
 
Upvote 0

Forum statistics

Threads
1,215,589
Messages
6,125,695
Members
449,250
Latest member
azur3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top