Pivot Table: run time error 1004

[ALEKSJAY]

Hi, I am having this error in Excel 97:
Run-time error '1004'
[Microsoft][ODBC Microsoft Access Driver]'D-BSPR'$ is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

This spreadsheet is in a shared folder and the other users are able to use it without having this error.

The line where this error occurs is:
ActiveSheet.PivotTables("PivotTable6&quot.RefreshTable

I know the Access file used to get the data is available, I can open it and see the tables and all the data, but I don't know which tables does this pivot table use, since I didn't create the spreadsheet

 

[Nikita6003]

Just a thought - are you using a DSN to connect to the data source? If you are, is this DSN set up on the PC wwhere you get the error?

Cheers
Nikki