•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is there a way to convert a formula reference to text for sharing?
Our take
When sharing a summary spreadsheet with clients who lack access to the original data, it's important to present information clearly and effectively. You may be looking to extract final values from formulas without revealing the underlying equations. Fortunately, there are methods to achieve this, allowing you to transfer the numerical results while maintaining the integrity of your data source. This approach ensures your clients receive the information they need without confusion or complexity, empowering you to communicate your insights effectively.
Odd question, not sure if this is possible or not.
I’m working between multiple spreadsheets, and pulling info into a summary spreadsheet. This spreadsheet will be sent to a customer who does not have access to the other spreadsheets. I’m curious if there is a way to pull an equation from one spreadsheet to another, without actually pulling the equation. I want to pull the final number, not the formula, as the customers won’t be able to access the info.
I’m certain there’s a way to do this, but I’m not sure how.
TLDR:
Want to pull references to other spreadsheets without actually referencing the spreadsheet for sharing purposes.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Exporting just one sheet?Looking for a clean way to do this. I've got a spreadsheet with multiple sheets that refence eachother for preparing data for a customer. Obviously I can just print one sheet but what I would really like to do is export the "customer" sheet as a new excel document. Ideally with some of the values becoming their data on the new sheet, but other cells keeping their formulas Example, first box would be what the cells on the export sheet output, next being their formulas. the second set would be how I would like to export, Hard coding the values as regular numbers that are referenced from a different sheet, but keeping the formulas that do math on the same sheet. Is this possible? https://preview.redd.it/cstcpxl78vqg1.png?width=181&format=png&auto=webp&s=f85a19322898ac8a3556d059ba1c5ad6dba7b867 =DifferentSheet!P7 =A1*10 =DifferentSheet!P8 =A2*10 =DifferentSheet!P9 =A3*10 https://preview.redd.it/s4xpp55h8vqg1.png?width=181&format=png&auto=webp&s=962737308118022dbc6a060481514fdc07c1e261 11.5 =A1*10 12 =A2*10 14 =A3*10 submitted by /u/223specialist [link] [comments]
- Extracting all formulas from a multi-sheet Excel file into R (best approach?)I’m working with a large complex convoluted Excel workbook that has multiple sheets, lots of formulas, and some circular references. The goal isn’t just to read the data, but to actually understand and reconstruct the logic. Just sick and tired of going back and forth between sheets, and I keep forgetting what the logic is. so I have to start all over again I'm currently going cell by cell and writing all the formulas so that it will be easier later on for reference as well But I don't know of a way to extract all the formulas at once in a markdown document and develop like a map or something I use R quite a bit, Is there an easy way to extract all formulas at once and map them ? submitted by /u/sporty_outlook [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- Building a dynamic formulaI'm using Excel to predict the capacity usage of storage devices. It's clunky, but it works great until someone changes the name of the SharePoint folder I'm using to reference my data. (This has happened twice) I had the brilliant idea (or so I thought) to dynamically build the formula using "concat", which I thought would allow me to simply change one cell and be able to affect all of my entries (about 65 rows). I then learned that "concat" only builds the formula, it does not evaluate it and that I needed to use "indirect" to evaluate it. That worked, except my output was "REF", not what I was expecting. After a little more digging, I found that "indirect" does not work with external workbooks that are not open on the local machine. (I don't want to open 60 workbooks to get the data I need) It looks like I am out of luck, but I am hoping someone else has a brilliant idea I have not considered yet. Thanks submitted by /u/Separate-Tomorrow564 [link] [comments]