Linking spreadsheets in Personal Vault I moved data to my Personal Vault (on OneDrive). I built a spreadsheet that links to data in another spreadsheet, in a different folder but same Vault. When I re-open the spreadsheet, it says it...Show More excel Macros and VBA Reply View Ful...
"id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1731977288000","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:o365.prod:pages/forums/ForumMessagePage:board:ExcelGeneral-1734099032961
Example: I have a spreadsheet A with prices, and a lot of other spreadsheets B-Z with calculations for estimates, based on prices from A. When changing a price in A, B will automatically update its calculation and show an updated estimate. This was a feature in Excel, and after so much...
Database files and spreadsheets are not the same thing. Only trying to help you get better answers. . p.s. Trying to use Excel to make something that appears like a database has resulted in many problems for my clients over the years. You might want to consider exporting your Excel...
I am a recent engineering graduate who, on the advice of some people more experienced than myself, has been compelled to learn Access since it can be a much better tool than many of the over complicated excel spreadsheets that many in our industry use. Basically here is my problem. My ...
Using the built in PEARSON() function in Google Spreadsheets you get a number between 0 - 1 to indicate how closely correlated two sets of data are, with 1 being a perfect correlation. I averaged each domains correlation coefficients against the others to produce a graph of how each domain'...
Excel contains a number of powerful tools to manipulate data; we hinder it when we try to format the raw data in output layouts. Again, that may not be what you're doing...but it kind of looks like it. If you could upload the raw spreadsheets, some of us here might be better ab...
stretched2thin (Electrical) (OP) 20 Jun 03 12:31 Does anyone know of a good way to link autocad tables to excel spreadsheets without using embedded objects? Replies continue below Recommended for youMrStohler (Structural) 20 Jun 03 13:08 I'm not sure how to do it. But you might ...
Current industry practice for review and comment documentation may be to use EXCEL spreadsheets and manual markup and scans of graphic documentation or electronic mark up programs that may require installation of proprietary program software on a user's system. These systems may require inefficient, ma...
Need a rename macro for excel BhagyeshVashi May 8, 2024 -Engineering spreadsheets Replies 11 Views 513 Jun 6, 2024 sdz Locked Question opening links (to other workbooks) ? 1 rb1957 Jan 4, 2024 -Engineering spreadsheets Replies 19 Views 384 Jan 30, 2024 IRstuff Share: Faceboo...