Extracting Hidden Reference Data

simonwitt

New Member
Joined
Oct 26, 2006
Messages
2
Hi,
A lecturer of mine uses a very sophisticated spreadsheet to determine the answers to an engineering assignment which is based on student numbers etc. Now that the semester is over he has created a second spreadsheet containing everyone's marks which uses a pivot table referring to the external file mentioned above.

As the pivot table file was so large, I opened it in notepad, and could read all of the worksheet names from the external reference file - from what I have read the program makes some sort of hidden copy.

Is there any way of extracting the reference file which seems to be hidden inside? I would be very keen to see how his spreadsheet works.

Thanks,
Simon.
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
So, you are trying to break in to a spreadsheet belonging to a lecturer of yours then? Or have I got that wrong?????
 

simonwitt

New Member
Joined
Oct 26, 2006
Messages
2
Yeah the assignment's all finished and done, so its just purely out of interest really.
 

Watch MrExcel Video

Forum statistics

Threads
1,112,798
Messages
5,542,569
Members
410,560
Latest member
1ndependent
Top