Hello,
I’m running a macro in my spreadsheet that goes through a slicer and prints a pdf for every slicer item. The thing is that the sparklines are not changing, in every pdf the’re the same like in the first one. Is there a way to get this fixed?
I can't attach my file (700 KB, xlsb), any idea on that (Error 106 - Upload file size exceeds maximum allowed size)?
thank you.
Hi rocketfinger
Using your original code, the PDF files generated by your macro Step_Thru_SlicerItems looks ok.
The sparklines are changing for each file. Refer attachment.
Don't see anything wrong.
Sunny
Hi Sunny,
Still doesn't work for me. Can it be some excel setting?
thanks
It is possibly a setting issue. Maybe you can try checking if your Excel Calculation Option is set to Auto or Manual.
You can also look into the File-Option-Formulas screen to check other settings. My guess is it is from here.
You can also try printing from another computer and see if it is the same.
Hope this helps.
Sunny
