PivotTable source file error - Drive disappears

  • I have a spreadsheet with 3 pivot tables. Each of these tables has a different data source coming from 3 different spreadsheets. All saved in the G: drive of the network. Every now and then, I get an error re Cannot open PivotTable source file. The "G:" part of the source has disappeared just leaving the rest of the reference. Any idea why this is happening (happens maybe once every couple of weeks)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!