Hi MH,

is the connection to the data source still there?

If yes,

- either access the data underlying the pivot directly in Excel using the already existing connection (DATA -> existing connections)

- or you try to use the connection string (visible in DATA ->Connection ->properties) in SSIS respectively without using Excel connection manager.

Kind regards,

Conny