Where are Database Numbers Stored?
Where are Database Numbers Stored?
(OP)
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
Regards,
iv





RE: Where are Database Numbers Stored?
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.
RE: Where are Database Numbers Stored?
RE: Where are Database Numbers Stored?
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
RE: Where are Database Numbers Stored?
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
RE: Where are Database Numbers Stored?
http
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
RE: Where are Database Numbers Stored?
This is exactly what I was looking for - I will give you a huge star. Thank you very much.
iv
RE: Where are Database Numbers Stored?
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?
RE: Where are Database Numbers Stored?
http:/
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: Eng-Tips.com Forum Policies