hi,
I have a file in Excel 2013 with 13 table, many pivot charts, slicer , time line with filter connection, it was working ok but after I rename the file and the problem comes. While refresh all, message comes up ' can not open pivot table source file'
As a solution I have changed the source data for all Pivot tables and reconnect the filter connection , again it works OK.
but-
I save as the file in different name in the same folder - same issue comes up .
I email the OK file to my friend, when he opens it .. the same problem .'can not open....'
I have tried a lot but in vain.
looking forward for help.
Regards,
Amal
I have a file in Excel 2013 with 13 table, many pivot charts, slicer , time line with filter connection, it was working ok but after I rename the file and the problem comes. While refresh all, message comes up ' can not open pivot table source file'
As a solution I have changed the source data for all Pivot tables and reconnect the filter connection , again it works OK.
but-
I save as the file in different name in the same folder - same issue comes up .
I email the OK file to my friend, when he opens it .. the same problem .'can not open....'
I have tried a lot but in vain.
looking forward for help.
Regards,
Amal