Forum

Mynda Treacy
@mynda
Admin
Member
Joined: Jul 16, 2010
Last seen: Jul 1, 2026
Topics: 0 / Replies: 4786
Reply
RE: Query not updating with additional workbooks added to a folder

Perfect, Neil. It's great to see you have the confidence to experiment with different things to find a solution. I'm always here if you get stuck, ...

10 years ago
Forum
Reply
RE: Query not updating with additional workbooks added to a folder

Nope! I'd need to see the M code to get at least an idea. Please also provide list of workbook names, including file extensions. Thanks, Mynda

10 years ago
Forum
Reply
RE: Combo chart with 2 or 3 axis?

Hi Damaris, Firstly, I have moved this post to our Members Dashboard forum as opposed to the public one which anyone can see. Please be sure to use t...

10 years ago
Reply
RE: Download the Workbooks (download just the new tutorial files here) Error

Hi Rick, Sorry about that. I forgot to set the permissions on the file. It's fixed now. BTW, I have moved this post to our private members forum...

10 years ago
Forum
Reply
RE: Get group data from Facebook ?

Hi Ann, Facebook changed their API in April 2015 and now it is only possible to get data from pages you own. It seems the group URL no longer conta...

10 years ago
Forum
Reply
RE: How to run subquery against data in data model?

Hi Troy, I think this post explains what Catalin was suggesting: Mynda

10 years ago
Forum
Reply
RE: Attempt to Create Dashboard. . .

Yes, that's the order you should complete the courses in. It sounds like the key piece you're missing is the 'practice' part. If you're just watchi...

10 years ago
Reply
RE: Attempt to Create Dashboard. . .

Hi Troy, I have answered your questions in the attached file, but I think a lot of the struggles you're having are because you haven't finished the...

10 years ago
Reply
RE: List Box

Hi Thomas, The list box will display the values in the list in the order in which they appear in the cells which feed that list. So, yes you can de...

10 years ago
Reply
RE: Vertical Axis Question

You're welcome, Bob. I recommend 2 VBA courses: Allen Wyatt's VBA for beginners or Jon Acampora's VBA course, which starts with a free introductory...

10 years ago
Reply
RE: Vertical Axis Question

Hi Bob, I see now that it's actually the minimum value that you want to change up from zero. Unfortunately this isn't so easy as the calculation for ...

10 years ago
Reply
RE: Vertical Axis Question

Hi Bob, Why do you think the Ghost series isn't influencing the vertical axis range? Note: the ghost series must calculate the MIN from ALL of your...

10 years ago
Reply
RE: What is Power Pivot used for? What is Power Pivot?

Hi Troy, Instead of adding the Pad.Start step to fix the number formatting, can you just delete the Changed Type step that gets automatically appli...

10 years ago
Forum
Reply
RE: Vertical Axis Question

Hi Bob, It won't have anything to do with Excel 2016 or 32 vs 64 bit. Your file isn't attached so I can't tell what's causing the issue etc. Please...

10 years ago
Reply
RE: Error details: Object reference not set to an instance of an object.

Hi Troy, It's like having the ability to create PivotTables from Access data all from within Excel. For example, you can model your data in Exce...

10 years ago
Forum
Page 318 / 320
0