Spreadsheet views on Co-authored Spreadsheets
Me and my colleagues have a shared spreadsheet which is co-authored, we have an account handler column which we can filter by our own initials to be able to view just our clients on the spreadsheet. The issue I'm having is often the default view is changing to a view with just one of my colleagues with the initials SD showing for all the rest of us. Would anyone know how to stop this happening, I have had this issue for months. Kind RegardsFile 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 TeamEXCEL FORMULA HELP
I need help. I have attached the sheet I'm working on. I need to pull the data in column B (CLIENT) from the MAIN sheet to the respective individual sheet based on column E (PREPPER). For example, if the data in B4 says 'Jason Smith' and E4 says 'Jon'; I need it to go to the JON sheet in cell B4 but not show up on sheets JANE or MARLA. Help please!! Thank you! :)
Significant Testing for a cross tabulated output
https://drive.google.com/file/d/164jBE8C9wNGNnad3gHkaAYhOnYfDd-8n/view Hi all, I have a challenge in performing the significance testing the attached cross-tabulated output for a few questions. I want to test the significance based on Town and Gender variables. Please help
Excel cell fill doesn't work.... !
Hi, I have all settings correct and still, randomly from time to time, for day or more, I cannot fill cells with data. It just taking first number from first cell and copy it ignoring numbers below, and only what I can see are formatting options (this where you change in ex. colour depends on data in the cell. Nothing seems to work, I have no updates pending, reset Excel or computer doesn't work. I use Excel daily and if this happen I have 1 or more days out of work possibility. What shall be fixed here? Help, please.What causes an excel file to 'Show Print Preview' rather than show the preview by default.
I am curious what causes this to happen, I have already set the print area etc., but for some reason I don't get an immediate preview when going to print, I have to click this button inside the print preview. (I have also attached the full screenshot Doesn't seem to matter what settings I change so far, just curious what exactly causes this change in excel, I have many other documents that just bring up the preview straight away when going to print, but at the moment, this one particular file I have to click another button. I have a MS flow that converts excel files to pdf automatically after a review process, but it keeps failing on this one file and I can't figure out why, but I think the key revolves around this, so I really want to find out what causes excel to present an additional button that you have to click to generate a preview rather than showing the preview off the bat like it does with every other file which works fine in the flow. Thankyou
Preventing duplicate selections
Hi all! What I'm trying to do: Once a company is selected on one employee's sheet, it's removed from the dropdown lists on all the others, preventing duplicate selections. Background: I'm builidng a workbook with 18 sheets- one per employee. Each sheet has the same structure: column A contains a dropdown list of client companies, pulled from a master list on a separate sheet (Company List). When an employee selects a company, related contact info (name, phone, email) auto-fills using XLOOKUP. My setup so far: - The Company List sheet stores the master list of companies and contact info. - Dropdowns in each employee sheet (column A) are already pulling from that list. - Selection triggers auto-fill of contact details (working fine)
