Last seen: Jun 10, 2026
Your match function will stop at the first match it finds, so you need to make sure your table has the most specific items first - eg January February...
Remove the #Changed Type step - it refers to all the columns.
You haven't posted the error, or the full current code. SaveCopyAs will not close the current workbook but it will leave it in the same state it was i...
In that case you can make whatever changes are required, then use ThisWorkbook.SaveCopyAs ThisWorkbook.Path & "" & Range("B15").Value ...
Also cross-posted here:
It will depend on how you removed the other columns. If you removed them explicitly then you'll just need to edit the query to remove the step that go...
You could use Replace.ReplaceValue instead of Replace.ReplaceText. It will have the side effect of converting the column type to Any rather than Text ...
What format is your template? Is it an actual template or a normal workbook that you use as a template and, if the latter, is it also saved in xlsb fo...
Your code works fine here in Office 2016. Do you get the error with any template or just a specific one? Also, you should learn the rules on c...
They are defined names. You can delete them with some code like this: Sub ClearNames() Dim nm as name On Error Resume Next for each n...
If you're using the data model, you could also create a set that only shows the second calculation at the grand total level, not the individual rows.
What is the actual error message? I did't get any errors with that one.
In the sample you posted it does work for weekly but not for daily because the daily pivot table is blank. Its data source is set to 'Station Data'!$Q...
Your pivot table's data source is set to a blank range, so you can't refresh it.
That's pretty hard to answer without seeing any of your code. 🙂