Drop Down Lists and Vlookups
Hi - Trying to understand if there is a way to do the following in the Process Name(s) column in my spreadsheet: The Plan Name column has a drop down option with a link to a list of plans. When you click on the relevant plan for you, the Plan ID and Primary Resilience Rep data is pulled through via Vlookup. What I now need to do, is to be able to have a drop down on each row in the Process Name(s) column that will contain only those Processes that are associated with the selected Plan ID. The user can then select multiple processes (one per row). Its almost like I need to do a cross between a drop down list and a Vlookup. Any help much appreciated Thanks James
Links between Excel and PowerPoint don't work anymore
For almost 10 years, I have pasted and linked charts from Excel into PowerPoint using Paste Special / Paste Link. To update the chart in PowerPoint to the current version in the Excel file, I would right click on the chart in PowerPoint and select Update Link. That worked fine until last week. Now, when I click on Update Link, I get the error message "The linked file was unavailable and can't be updated." The PowerPoint file and Excel file are both in my One Drive. I haven't changed the name or location of either the PowerPoint file or the Excel file. I spent an hour online with a tech who ran various repairs on my Microsoft 365, but nothing helped. Does anyone know how to fix this problem? (I used to link charts from Excel into Word files, but that stopped working a couple of years ago.)
Excel keeps resending spreadsheet link to users
I created an excel sheet in Microsoft 365. I invited 4 users to the spreadsheet. For some reason it keeps resending the invite link to all 4 users every 30-40 minutes and I can't make it stop. It's blowing up their emails and they're getting frustrated. Please help me make it stop! It's resending the invite link even when no one is working or updating the file. I added a screenshot below for reference. How I shared the spreadsheet: Share>Share>Add a name, group or email> entered users names one by one and added them>SendDisable Copilot in Microsoft 365 Personnel et Famille
Hi, I was particularly annoyed to see the Copilot icon appearing recently on all products (word, excel,...). Impossible to disable it on Mac. Particularly bugging as I definitely do not want to either test or use Copilot. What can be done? Or when the issue will be solved? BR
How to achieve easy file update on Powerbi repository
Hi, I am new to powebi and I am trying to understand if powerbi could be the answer to a challenge that I have. I receive a monthly excel report file (always with the same format and schema) from a partner. I would like to have a dashboard that visualised the report content. I can achieve this when I link the one file with powerbi, however, I am not sure how to handle the monthly increments. Do I need to have some kind of master file that every month I manually update with the data from the new file that I receive, or is there a smart solution where I can just drop the file into a repository and Powerbi will automatically fetch all files in the repository? Any ideas are welcome. Thanks
to big title bar in Office 365 update 2408
Hi all, since a couple of days I have to work with the ugly, annoying, awful, ... user interface in Office 365. The title bar size became horrible large. Compared with an explorer window from Win 10 it is nearly the double height. As an Office Poweruser (I'm working with the office products (Word, Excel, Powerpoint, Outlook) unluckily the whole day) I'm looking for smallen the title bar again. There was a registry hack, but on my machine this isn't working anymore. Because of the ribbon interface and a lot of not needed functions this is how my Quick Access Toolbars (QAT) are looking like: Now somebody could tell my, "OK, switch the QAT to the top, so that the title bar get more sense! Problem is, that the monochrome icons are absolutly boring AND especially for Word I can't differ between my macros, which I set with different colours. The title bar is smaller because of the standard buttons and the search field, so that not all my most loved commands have space here Dragging the window can not be done with the title bar, as it was since the beginning of time. I need to find some space somewhere. Does someone have an idea to reduce the size of the title bar as it was before? Or does someone have an idea to colorize the icons, when they are inside the title bar? If I consider that the taskbar is also increasing in size, especially in WIN 11 where this isn't adjustable, both sides (top + bottom) in sum are steeling to many space. Cheers! KayExcel - Unable to access Office Add-ins
Morning all, I'm having an issue for months regarding accessing Office Add-in portal within excel as I'm getting "Cannot connect to the catalog" error. I've done all of the test that I can think of including testing on a separate PC. Logging with my domain account, I can access and install an Add-ins within excel but when the user is trying the same on the exact same PC (using her Domain account, of course), we're getting the same error. No problems with the network, Office has already re-install on her laptop and for the laptop that we use as a test, it is a newly build machine. Thanks and regards, Mark
UI for custom font and color schemes in Office for macOS
Hello, I am not 100% sure if this is the correct discussion space, but: until now there is still no user interface for macOS users to create a custom font or color scheme! On Windows it is so easy; on macOS you have to dig up weird directories and write an XML file. What gives? Best, Satrio
Turning off email notifications about new comments in one certain file
Hi All! I found a solution to turn off all email notifications on new comments in my shared files (through settings on SharePoint), but it doesn't really solve my problem. In project files I work on with my colleagues, email notifications are helpful for monitoring workflows and streamline the process. At the same time, I'm an owner of yearly excel files shared with a big team in order to monitor the work on all clients and automate the visualization of it, but it gets commented on a lot and I don't need to get all of that on my Outlook. Is there any way to turn off email notifications about new comments for just one file without turning them off on all my shared files? Kind regards, Jakub Banasik
