Forum

Hi Joacim, No idea why investing.com is not returning data, maybe they don't want to, some sites are using anti-bots to stop crawlers. Looks lik...

Yes, you can write before or after the loop from cells: Print #FileNo, "Introduction" Print #FileNo, "Whatever" For Each Cell In Rng ...

See if the attached file is working as expected. Setting DisplayAlerts to false is redundant, the file name contains a unique time stamp, it's impo...

Hi Lisa, Can you upload a sample chart and describe what element you are trying to move?

Hi Chirle, The embed option is available only for OneDrive Personal, not in Onedrive for Business. If you are using OneDrive for Business, this ...

Hi, You mentioned that you want the result to contain only column A, now I guess you meant column A and column B in a single column, is that right?...

Hi , Try the attached file. First, Make sure you install the Power Query add-in from Microsoft: Before pressing the button to Import-Export, chan...

Hi, Can you upload a sample csv? It looks like an xml file to me, but you also have values outside the field tags.

You're welcome 🙂

Hi Kevin In Pivot Table Tools ribbon tab, in Design tab, there is a predefined set of Chart Styles. If you use one of those, excel will not change ...

Hi Elinor, Try the attached file. The button to start the code is in raw data sheet.

Hi Anahita, There is no other way that I know for moving an item into another group, I'm afraid un-grouping and regrouping is the only way.

Hi, A slicer can be connected to multiple Pivot tables reports only if they have the same pivot cache. I the data source for some pivots is differe...

Unfortunately, it's a known bug with no solution yet. If you choose one of the suggested layouts, this will not happen. The only way is to use vba .

Catalin Bombea said Then, all you need to do is to change the location in the Location table (it is Milano, Italy now), change to whatever location ...