Register
Log In
Unanswered
Home
December 21, 2016
Offline
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.
Dashboards
June 25, 2016
Offline
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
December 21, 2016
Offline
Hi Sunny,
Still doesn't work for me. Can it be some excel setting?
thanks
Dashboards
June 25, 2016
Offline
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
Most Users Ever Online: 57
Currently Online: KingTamo
13 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Nicholas Agutu
ovais godil
Harry Singh
kailayamurthy k
kichu keen
ibrahim mostafa
sarvajit patel
Sheena Fletcher
Mkululi Sikosana
Sethu nath
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
