I am getting "Can't open pivottable source file '[abc[1].xlsx]Data" error when I
open the file after downloading it.
This file has pivot table.
If I save the file and open it , the pivot table is visible. If I open directly the above message is shown and pivot table is not visible (Other data is visible).
In 2010 , I could set the protected view settings and resolve this issue but I disn't find any such setting for 2007.

How do we fix this for excel 2007?

Let me know if you have questions