Forum

Ah, Alistair I presume you are somewhere in Europe, or at least in a region that uses semi-colons where I would use a comma. When you open a file cont...

Hi Mike, Welcome to our forum! Sorry for the slow reply. Your question was attached to an old thread, so it was missed. I've moved it to a new topi...

Hi Marc, You just need to turn them on. Select cell A2 > right-click > Subtotal "Day". You can change their position via the Design tab. ...

Hi Mat, No, you don't need to re-do your queries if you've made changes in the final query in the Other Queries folder. You'd know if you need to m...

Hi Maria, In step 3, 'Remove Other Columns', make sure you keep the column that contains the file name. Mynda

Hi Alistair, That looks like a bug! I'd send a frown to Microsoft by clicking the Feedback icon on the Help tab of the ribbon, or the smiley face i...

Not that I'm aware of, sorry.

Hi Ahmad, As I mentioned in my reply to your comment on my YouTube channel. It looks like your data is in the wrong format. The layout of your sour...

Hi GK, You can set PivotTables to refresh at set intervals via the Connection Properties: Data tab > Queries & Connections > Connectio...

Please share your file, Louise. I suspect you have a locale issue.

Hi GK, I answered this question in the 'note' in my reply. Mynda

The answer is, it depends! There's not enough information to answer your question. If the end result of what you want is what you see in the Pivot...

Hi GK, Thanks for sharing your file. It's perfect. You can add a conditional column that tags the data with "Yesterday&time" and "Today&...

Hi GK, Glad I could help. Please post your new question as a new topic and include a sample file. Note: please don't link the sample file to a C...

You're welcome, Azid. We don't teach JavaScript for Excel yet as it's not fully developed, but learning JavaScript in general will give you a head sta...