Forum Discussion
Excel Macro or Pivot Table Help
Hi PieGuy
i refer to excel files with csv extensions as csv files! the output file is, in fact, an excel file with a csv extension Very confusing. Not my call though...
I assumed you would have to do the same thing on a regular basis...
- Download the attached file
- Go to sheet Param
- In B1 enter the full path to your non-csv file
- Switch to sheet QueryOutput
- Right-click in the blue table > Refresh
Lorenzo WOW! Thanks so much. It looks amazing. i was having a little trouble replicating it though.
- I exporting a new source file,
- saved file to my hard drive
- copied that file pathname to Param / B1
- went back to Output Query and right clicked and refreshed and nothing happened. any suggestions? Thanks again for all your help. the final product is perfect.
...went back to Output Query and right clicked and refreshed and nothing happened. any suggestions?
Nope 😞
Within Excel, go to Data (tab) > Queries & Connections (a pane opens on the right side of the screen)
#1 Do you see a triangle next to QueryOutput?
#2 If you see a triangle:
- Double-click on QueryOutput (the Power Query Editor opens)
- Click on the last APPLIED STEPS (on the right side of the screen)
What is the exact error message?
Lorenzo 1. No triangle. When i open up Data > Connections (I use a macbook) it brings up the following screen. Thanks!
I use a macbook
This explains things. The query was designed on Excel for Windows. Unfortunately Power Query on Excel for Mac isn't at the same stage yet and I have no idea which version - if any - of Excel for Mac would allow refreshing that query
Nothing else I can do for you I'm afraid. A suggestion though: for next times please read Welcome to your Excel discussion space!