"Paste Link" remains gray and not accessible

[Corried]

Hello Excel world,

I have a problem...
I am trying to copy a table and link the table by pasting it into another workbook. But he" paste link" is gray out.

What do you suggest I do to fix the problem? Please view the video below...

Thanks in advance

Cheers.

https://drive.google.com/file/d/16TupRd ... sp = sharing

 

[jkpieterse]

Perhaps this gets you started How To Import Multiple Files With Multiple Sheets In Power Query | How To Excel

 

[mamady]

Mamady. I followed your direction step by step and it works wonderfully. I have managed to paste the data on the same worksheet, change some data and refresh query and it work...

My plan is to link "GDP" values with each country which represent a worksheet.

However, In some workbook, I have over 180 worksheet. If I plan to make a a query for each one, what would happen when it refresher query al at the same time?
I am not sure, I am afraid query may break or my computer may become unresponsive.

What is your views?

Best Regards

Corrie

Thank you For Your Support And Your Passion To Help Others...

Hi Corrie,

There is no straight way to assess your computer capability for MS Excel computing power. I would recommend doing the query for few sheets, let's say 5, change/update the data and refresh and see how much it will take for your computer to process those, then double the number as you go. Once you feel that your computer started to struggle you would know how much it can handle at once.

It depends on whether it is an incremental change, or the whole set of data are changed. Moreover, please note that you can refresh a specific table instead of refresh all. Just select the table and choose Refresh from the ribbon.

Best Regards
M. Yusuf

 

[Corried]

Perhaps this gets you started How To Import Multiple Files With Multiple Sheets In Power Query | How To Excel

Hello Jkpiterse. Thanks for your reply. The link you have send for me yesterday. I ahve followed. I am not sure if I have done anything wrong, but during the process, I am getting an error in power queries

I am not seeing the double arrow icon and I can not expand the data, for some reason.. I am stuck here for the moment.

What do you suggest I do?

It songs link these are the only options left for me...

Thanks in advance

 

[Corried]

Hi Corrie,

There is no straight way to assess your computer capability for MS Excel computing power. I would recommend doing the query for few sheets, let's say 5, change/update the data and refresh and see how much it will take for your computer to process those, then double the number as you go. Once you feel that your computer started to struggle you would know how much it can handle at once.

It depends on whether it is an incremental change, or the whole set of data are changed. Moreover, please note that you can refresh a specific table instead of refresh all. Just select the table and choose Refresh from the ribbon.

Best Regards
M. Yusuf

Hello Mamady, thanks again for stopping by this time...
I am ashamed to say. eventually I'll have to upgrade my computer.

For that reason alone, I requested to the forum, if I can transfer the data without using power queries.

However, Jkpiterse. Made a good suggestion. If I can use 1 query to transfer the data into 1 worksheet. Each table separately, I can grab the data from there for each worksheet and for each chart.

Please tell me if the suggestions sounds crazy to you. If so, it's okay. I'll understand...

Thanks in advance for both response.

Corrie

 

[mamady]

Hi Corrie,

Unfortunately, I am not an expert with power queries, thus can't advise about it.
However, try it out. I wish you luck

Best Regards
M. Yusuf

 

[Corried]

Hi Mamady

Thanks again for your support and your contribution.

Maybe I'll will meet you again in the near future.

Best Regards
Corrie

 

[jkpieterse]

I am not seeing the double arrow icon and I can not expand the data, for some reason.. I am stuck here for the moment.

Hi Corried,

Can you please post some screen-shots of what you are seeing? Please make sure you include the headers of all columns in the screen-shots. If needed, scroll to the right to catch columns which are not in view.