Hi all,
I prepared one XLSM tool with buttons in Excel 2013. One of then make Pivot table.
All it is ok.
Please Login or Register to view this content.
But I test the file with 2007 and have an error message "run-time error 438" when I create the Pivot table.
Why?
Thank you in advance for answers!
Rodich
Last edited by rodich; 03-23-2015 at 05:35 AM.
?If you have an apple and I have an apple and we exchange these apples then you and I will still each have one apple. But if you have an idea and I have an idea and we exchange these ideas, then each of us will have two ideas.?
George Bernard Shaw
Hi,
just a shot in the dark but I would be looking @ this:
2007 is version 12Please Login or Register to view this content.
2010 is version 14
2013 is version 15
Last edited by dlow; 03-20-2015 at 10:11 AM.
Wow! thanks a lot
I'll try!!
No problem, each one teach one :D
Let us know how it works out.
Sadly if that doesnt work I wont be of any future use/help to you I dont know anything about PTables.
Good-luck
Hi again.
It does not work.
Is it possible to have restriction for use TableDestination of Pivot table in another sheet?
I replace the code with
and the program return error in Set PT1 = ActiveS....Please Login or Register to view this content.
It's working withPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks