How to make all users in a shared excel anonymous
Hello, I want to make an excel document in order to evaluate people. The problem for ex: lets say people evaluate each other from 1-5. I want to share an excel document with all my colleges, so they can rate each other. I want to keep this anonymous but all of us are logged in Microsoft accounts, so even if its only by the link we can still see who is writing what. The solution I have now is to ask everyone to open the document in a web browser in incognito mode. Is there a way to set all users using the excel document to be anonymous? Thank you for helping! 😄
Excel basic IF statement does not work
I have an issue with using the IF function. Originally I wanted to only execute a specific function if todays date was after a certain date. I used =IF(TODAY()>=DATEVALUE("01/03/2022"), SUM(D3;-D8;D9), "") I tried different versions but every time this pop-up appeared: So I figured the statement was probably wrong and I resorted to trying out the basic statement from the manual (=IF(C2="YES",1,2), still the same pop-up appeared. I scoured the net and found that maybe I had to change my regional settings so I did that but it still does not work. Does anyone know why I can't do even the simplest IF statements? I use Microsoft excel for Mac version 16.57
Can I update a list in excel when linkex to a email contact group
Hi. Hope someone can help. I have a list of people in my department at work, whos names are contained on an excel spreadsheet. The same list is contained in an email contact group, and the email group is updated when people join and leave the company. Unfortunately the spreadsheet list seems to not have been updated at the same time and therefore has become out of date. What I would like to achieve is to link the email contact group to the spreadsheet group and when someone is added or taken off the email group, the spreadsheet automatically updates. Is this possible.? I am using Windows 10.
Excel 2016 Autoexpanding a table
Hello everyone I would like to learn if there's a way to autoexpand tables that have like different sections. For instance, consider this image: Here, I have a Table with a "Total row". But if I want to add a new row, I have to insert it. I was wondering if there's a way to always have an empty row, waiting for it to be filled, or something like that. I know is a small detail, but if there's a way, it should be simple as well. Thanks in advancePivot tables - Change Connection not refreshing.
Hi Team, I have a Excel file with 300+ pivot tables connected to SSAS cube. Now I need to change those connection to POWER BI dataset. But The connection gets stuck, showing.... 1. refreshing the cube 2. wating for query execution Finally gives error as... below. PLEASE HELP TO FIXHabilitación de Macros en archivo excel
Buenos dÃas a mailto:tod@s: Junto con saludarlos y saludarlas y esperando que se encuentren bien, quiero solicitar vuestra ayuda dado que en un archivo que me han enviado posee macros, éstos los habilité desde la opciones, pero sigue con el mismo mensaje al abrir el archivo: "No se puede ejecutar la macro...puede que la macro no este disponible en este libro o que se hayan deshabilitado todos los macros". Espero me puedan orientar. Saludos a todos y todas
I have a link that I would like to stay active when "filtered" to a different sheet. HELP!
I have an Excel that I have a link listed in sheet 1 "Master" I have filtered this sheet to separate sheets using the technician name. Each technician has their own sheet. However, when I do the live link becomes inactive. How do I keep he link live. I have attached a link to the workbook below. Thanks! Link: https://1gman-my.sharepoint.com/:x:/g/personal/megan_gerany_onegm_com/ESbAs7LUOOxBtCmCLm6E098BBPZTB6urnjgSlRaWgjCldw?e=3adEpX
