Where are Database Numbers Stored? 2

[iv63]

I made calculation spreadsheet using beam properties saved in separate file “C:\Sections.xls”. I sent the calc sheet to my friend but I forgot to attach database file Sections.xls. I was very surprised that it worked without database file. It looks like database numbers are saved inside of calc sheet and I am just curious where these numbers are stored. Attached is a test file.
Regards,
iv

 

[LiteYear]

By default, Excel saves the values pulled from a source file into the destination file. It only updates then when the source file is open. You can tell the source file is open because the address to the source file in the formula will change from 'C:\path\to\[file.xls]' to just '[file.xls]'.

You can change this default behaviour in Excel Options -> Advanced -> When calculating this workbook -> Save external link values.

So to directly answer your question, the values are stored in the Excel file.

 

[SteveGregory]

As long as your friend doesn't need the properties of a W10x19 or W10x26, the properties for the initial beam lookup (W10x22) will remain with the sheet.

 

[IRstuff]

Actually, it looks like the entire table is cached. If you pulldown any of the other beams, new values come up.

TTFN
faq731-376

 

[iv63]

IRstuff:
That is correct - the entire table (or better say complete external workbook) is stored somewhere. Therefore the entire table (or external workbook) should be “restorable“. How? Using VBA?
iv

 

[IRstuff]

You can simply copy the references onto a blank portion of the worksheet and go from there. I've taken the liberty of doing so; I think I have the entire table.

http://files.engineering.com/getfile.aspx?folder=58e61d08-9b08-401f-9373-050502d70d19&file=Test2.xls

TTFN
faq731-376

 

[iv63]

IRstuff:
This is exactly what I was looking for - I will give you a huge star. Thank you very much.
iv

 

[chemebabak]

IRstuff,

You did not answer the original question. Where are the references stored? You pasted the cached data in the same worksheet. From where (or how) did you copy the cached data?

 

[IRstuff]

OK, for the record, Excel's file structure was programmed to store external references as earlier answered by Liteyear. It's described here:

http://msdn.microsoft.com/en-us/library/dd773226(v=office.12).aspx

As for the actual sheet, it contains a snippet that references cell locations in the external sheet. So, by copying that reference to another location in the sheet, you can drag copy the cell until you find the boundaries of the table.

Voila! so simple, once you do it...

TTFN
faq731-376