•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Mirroring a sheet to be read only?
Our take
If you’re looking to share a specific Excel sheet without granting edit access, mirroring that sheet to a read-only file is a practical solution. This approach allows you to maintain a master copy while ensuring others can reference the data without the risk of accidental changes. By utilizing Excel’s features in Office 365, you can achieve this seamless linkage, ensuring that any updates made to the master file automatically reflect in the mirrored version. This way, you can confidently share data without compromising its integrity.
Hello,
I have a rather important excel file at work to keep track of some things. I want to share one sheet of this file with others so they can reference the data when needed, but not have edit access.
I tried password protecting it, but it is somewhat awkward with how often it needs to be updated.
So I would like to mirror just one sheet of this file to another file. So that when the master file is updated, the mirrored file also updates with the changes. But at the same time, the mirrored file isn’t editable by users. I could share this mirrored file with others and not have to worry about someone editing or breaking the master file.
Is there any way to smoothly do this? Or is there some other way of going about sharing this data I haven’t thought of.
Edit: I am using the latest version of excel included with Office 365
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to create a mirrored printable data from certain cellsso I made the pivot from blue collar work to the office at my company. I’m not super familiar with excel and have just began using it. there are excel forms that sales uses to fill out certain customer information that has to be accessed at a different time to provide information to the shop floor. I’m trying to figure out a way to make those certain cells auto populate in an easily accessible and printable form. a pdf would be preferred but I’m not sure if that is possible. the idea is to print the information to include it with the blueprints so that the operator doesn’t have to spend his/her time looking through and for the documents . if anyone can point me in the right direction I would appreciate it! submitted by /u/BlingBlingCrackPipe3 [link] [comments]
- Privacy Setting for ExcelSo I have a question for the excel experts out there. I’m still fairly new to excel and need help adjusting privacy settings on my excel. So I have a sheet the is labeled “Database” that stores a bunch of entries for invoices my company has for the year. I have another sheet in the same workbook labeled “dashboard” that has some sensitive financial information on it. I want to be able to share it with a coworker where she can only see the database side so she can help me enter data point, however I don’t want her to be able to see the dashboard sheet. However, I want my bosses to be able to have access to it easily, they aren’t always the most tech savvy so hiding the sheet may not be the best option. Maybe try and password protect the sheet? For reference we also only use the one drive and excel online version, I know sometimes that doesn’t offer all of excels options. submitted by /u/SwingAnxious6016 [link] [comments]
- Mirroring One Tab to Another, But Not Vice VersaGood Morning All, I'll try and be as TL:DR as possible. I am entering the ever-dreaded income tax season. I am also the only person in our office under the age of 60. Needless to say, my one partner cannot stand Excel, which is unfortunate because I live on it. One reason he doesn't like it is because I have all kinds of formulae calculating how many returns I need to do per day to finish by a certain date, and several other similar computations that keep me on track, in control, and therefore less stressed. He wants to phase Excel out altogether. My (secretive) compromise is to remove all of the formulae that are really just for me anyway and "dumb" the spreadsheet down to just the client name and the date it was received. I would, however, (and here comes the secretive part) like to have a separate tab that retains all of my formulae but pulls from the "dumbed" down list so I don't have to enter client names and dates received twice. Is there a way to mirror another tab where one has only client name and date but my other tab has a bunch of my original formulae on it? I know I can = another tab, but the problem is I sort returns alphabetically, by which ones are complete vs. not, by which ones got extensions, etc. so it's not just a straight down list. It constantly gets re-filtered. Any insight would be great. I can probably mess with it and just do =$ calculations, but if there's an easier way, I'd love to hear about it. Also, the Excel nerd in me loves learning new things anyway, even if I can do it my own way. Thanks! submitted by /u/arsenalffs [link] [comments]