Hi all,
just wondering if there is a way of linking two separate pivot table in Excel 2007 therefore changing one of the names in the drop box and both tables change. I know you can do it in the new version which I have on my own laptop but this is the works laptop and we are so far behind when it comes to IT....
any help would be appreciated.
Steve</SPAN>
just wondering if there is a way of linking two separate pivot table in Excel 2007 therefore changing one of the names in the drop box and both tables change. I know you can do it in the new version which I have on my own laptop but this is the works laptop and we are so far behind when it comes to IT....
any help would be appreciated.
Steve</SPAN>
