×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Where are Database Numbers Stored?
2

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

RE: Where are Database Numbers Stored?

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.

RE: Where are Database Numbers Stored?

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.

RE: Where are Database Numbers Stored?

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

TTFN
FAQ731-376: Eng-Tips.com Forum Policies

RE: Where are Database Numbers Stored?

(OP)
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

RE: Where are Database Numbers Stored?

(OP)
IRstuff:
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?

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?  

 

RE: Where are Database Numbers Stored?

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: Eng-Tips.com Forum Policies

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources