Hidden raw data file in my computer?

[Isaac Many]

Hello,

One of my clients sent me a file which has one sheet only - a pivot table.
When I'm trying to get the data source, it shows: '\Users\Isaac\Desktop\[SupplySheet_External-Jan_RAW.xlsx]Inventory_Avails_Sheet_01_02_20'!$A$1:$BB$447187

The file they sent me is "SupplySheet_External-Jan.xlsx" (and that only).

They probably don't want me to have access to their raw data, but my questions are:
1. can I have access to it?
2. why does the referrer point to a file located in my computer, while there is nothing there but the pivot file?
3. How can I do it myself?

Thank you!

[davsth]

Is the file sent to you called SupplySheet_External-Jan_RAW.xlsx that "just" contains the pivot table?

If so there is another tab in the workbook that is either hidden (or very hidden) or is visible and the sheet tabs have been removed

you need to either:
go into your excel options and enable the sheet tabs
click on the sheet tab and click the right button and choose unhide

if these don't work you need to run VBA code to unhide the data,

Please Login or Register  to view this content.

[Isaac Many]

Hey,

None of these worked because it's not the sheet that's hidden. it's the file.

This is what I got from my client (the "pivot" file): SupplySheet_External-Jan.xlsx
This is the source data the pivot is referred to: SupplySheet_External-Jan_RAW.xlsx

Different files.

[Isaac Many]

Hey,

None of these worked because it's not the sheet that's hidden. it's the file.

This is what I got from my client (the "pivot" file): SupplySheet_External-Jan.xlsx
This is the source data the pivot is referred to: SupplySheet_External-Jan_RAW.xlsx

Different files.

[Isaac Many]

Can anyone help?