Fix for Excel Error : Cannot Open Pivot Table source File

Fix for Excel Error : Cannot Open Pivot Table source file
When an excel file is downloaded from a web link or a shared portal, we receive the following error - Cannot open Pivot table source file. The source file was pointing to the shared portal / web link.

Solution for Excel 93 - 2007

1) Highlight (just select) the Pivot table
2) Go to Options tab - Under the "Change Data Source" change the table range to the local sheet name and range.
3) Refresh the Pivot table and it should fix the problem