"Cannot open PivotTable source" when trying to refresh it

L

laruvv

Hello
I have a pivot table opened from the web(intra).
The filename changes from test.xls to test(1).xls
When I try to refresh this test(1).xls it says
Cannot open Pivot table source file'[test[1].xls]
Why it has changed the filename to test[1].xls??
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show if file is opened in read only 6
Pivot table report invalid 0
Please help! Cannot open pivotTable source file.... 2
Excel 2013 Pivot Data Range formula reference problem 0
Office 365 Outlook adding unwanted HTML to Email Body 0
Macro to Select text from a point given to a specific word 2
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Excel 2013 cannot open simple text file with .acc extension 1

Top