Last seen: Aug 8, 2025
Have you looked at this tutorial?
You will need to unprotect them either manually or with VBA. Then once you have refreshed the query, then protect either manually or with VBA
crossposted: Please read:
Can be done using Pivot Table and calculating the differences year over year. See the attached
crossposted:
Will this presentation work for you. I did this in Power Pivot and the link to show you how I did this follows.
Thank you both. I now have it working with both solutions. Just so you know, I was working off one of Phil's Blogs as an example. Good on both of...
@Catalin. Tried your suggestion but it did not compute. PQ did not accept the line of Mcode. Did not throw an error, but did post some gibberish in...
Check your connections and see if you have Excel refresh the query upon opening. If so, you can turn it off if you don't need it to refresh.
crossposted: Suggest you read:
crossposted: and
Would be really helpful if you supplied some sample data in an attached file. Probably only need 6-8 records that are representative of your actual f...