I use a Mac for work, and I have to send pivot table reports to colleagues and clients that use both PCs and Macs. I am using Excel 2007 to create the pivot tables, and I am having a lot of problems with producing a pivot table that looks the same on both Mac and PC.
Creating the pivot table on my Mac is such a pain, so I am now creating the tables on my personal PC. After I get the pivot table created and formatted it works/looks great on the PC, and any PC users I send it to. The problem I am having is when I send it to Mac users. All formatting seems to lost/messed up, and I can't seem to fix this on the Mac. I need the pivot tables to look professional and consistent for everyone I send them to, PC or Mac.
I am wondering if I need to write a macro to make the formatting stay the same on the Mac, and if I do, I am wondering how to do that? If anyone could help me out with this I would really appreciate it! Thanks!
Creating the pivot table on my Mac is such a pain, so I am now creating the tables on my personal PC. After I get the pivot table created and formatted it works/looks great on the PC, and any PC users I send it to. The problem I am having is when I send it to Mac users. All formatting seems to lost/messed up, and I can't seem to fix this on the Mac. I need the pivot tables to look professional and consistent for everyone I send them to, PC or Mac.
I am wondering if I need to write a macro to make the formatting stay the same on the Mac, and if I do, I am wondering how to do that? If anyone could help me out with this I would really appreciate it! Thanks!
