I am sorry Catalin for assuming you know my situation.. I am using the power query that you suggested, and create only connection without loading d...
thanks Catalin for the info. I know my issue now, i put wrong filtered location on pivot tables. 😛 Now i found some of my pivot tables appeared th...
Hi Catalin, I have issue on scrolling the data on power query editor,i wanted to check how many of the total rows on that page, but i have difficul...
Thank you Catalin. I will let you know if everything success after i complete.Thanks very much! 🙂
Yes. I do not want them to refresh it. 🙂 Yes, sorry, i have 3 external source total. Because the rest two data source is having all same issue, so...
Yes i able to change the column to integer now. But i have values with bracket (eg : (234)) , this one can be remove with power query too? One of t...
Yes. I can set up the connection on power query now 🙂 Attached sample file for your reference. Its great if can reformat the data from text to int...
Hi Catalin, Its not local database,i am connecting to our company's live database. Oh..IP an alternative way, why can't i think that 😀 can conn...
Hi Catalin, I am using excel 2013, pro plus. Now i am trying the rest pivot tables to connect directly to database but the pivot tables won't s...
Hi Catalin, Yes you are right. Now i have another trouble again, i linked up the pivot table with my database server data, now the slicers does ...
Oh Catalin, bravo! 🙂 You know that i have been tried to put like your way as pivot table previously ,but it showed as compact form by default, i d...
Thanks Catalin for your kind patience and efforts to help me clarify all the things. Attached my example code hope can make clear situation.My inte...
I've tried to put Application.ScreenUpdating = False and even Application.EnableEvents=False on defined table code, but still not working. The slicers...
Hi Catalin, I am sorry for my bad english. I have misunderstand the "detach" meaning. I wanted to ask how to connect slicers one 😀 I've tried i...
Hi Catalin, Thanks for your help.Glad to receive your response. I am newbie on macro, sorry that i am still not understand the code meaning. ...