Excel Community: Simplifying Spaces and Labels
Hi all, As you may have noticed already, we as the Excel Team have done a bit of "spring/summer cleaning" for the community. We have received feedback that the number of "spaces" was simply too many at nine, so we have pared things down. Now, there are three community spaces: Excel: this will be the primary place for posting content, as many of the old spaces have been migrated as labels will find a good home here BI and Data Analysis: this will be a good place for posting about tasks and questions that cut across Excel, Power BI, and other topics in this realm Resources and Community: this will increasingly become a place for folks to share sample files and templates with each other Q: What happened to the other spaces that used to exist? A: They have since been rolled up as "Labels", which you can find in the "More Resources" sidebar under "Labels" of any of the three spaces mentioned above. Look for these on the right side: Please let us know if you have any other questions. Thanks for reading!File Attachments
🚫 Reminder: Do Not Share Real Customer Data or PII in the Community As a friendly reminder to all members of the Excel Community: Please do not post any content that contains personally identifiable information (PII) or real customer data. This includes names, email addresses, phone numbers, account numbers, or any other data that could be used to identify an individual. 🔒 Protecting privacy is a shared responsibility. If we suspect that any content contains real customer data, community administrators may remove it without warning to protect privacy and ensure compliance with our policies. Per our Terms of Use : You should only upload content that you have permission to share. If you're sharing examples or screenshots, please use dummy or anonymized data. Clearly indicate in your post that the data is fictitious or anonymized. Let’s work together to keep the Microsoft Tech Community a safe, respectful, and productive space for everyone. If you find a post with content likely to be personal in it then please report the post using the cog in the top right corner. Thank you for your cooperation! Microsoft Tech Community Admin Team
How to limit "Forwarding" of a shared Excel Workbook
Hello, I am trying to understand if this is possible so please bear with me. I have shared access to my Workbook with an individual from another agency, which is working well. They in turn shared it to a coworker without my knowledge. Thankfully there is no inherit confidentiality concerns but it presented a problem. I never received an email about the "forwarding" and was only made aware when Individual A informed me they had shared it with their coworker. They did receive an email that it was "shared" but I did not. Can I limit who shares access to the workbook? The only permissions I am able to see that are changeable are "Edit" and "View" When I am using the word "forwarding", I am thinking of how you can forward a scheduled appointment in Outlook, which sends an email to the host, letting them know the meeting was forwarded. Thank you so much for your help.
An unhelpful Error Message
This is for the Microsoft folks who monitor this forum. I was attempting to respond to a question a few minutes ago and got the error message that appears at the bottom of this image. Note: I had not added any HTML myself. I had copied and pasted the items in the bulleted list, so it's possible that something carried over from Google...but in either case, that message -- how should I say it? -- contains invalid tech-speak. I was able to post the reply by eliminating the bullets, but those bullets had been added by, you guessed it, the forum's own software. Does the TechCommunity's left hand know what the TechCommunity's right hand is doing?
Auto populating multiple sheets from a master sheet based on a category drop down
hello. We are a start up and are currently using a master list to track all external meetings until we determine the best CRM system. This master contains 14 columns of data, hundreds of rows of contacts. I'm hoping that everytime someone enters a new meeting, it could auto populate a secondary sheet based on the category/industry of the client (ie all auto meeting are copied to an Auto sheet in the same workbook). I want to the whole row of info to copy over so at the end we have the master and then ten or so industry sheets. Is there a way to do this automatically or am I stuck copying and pasting constantly? Thanks
