Data Extraction and Manipulation
Right. So I have been trying to achieve the following; Extract Key Data from a structured PDF > Push this Key Data into a Word/Excel document I can get parts of this process to work. Copilot seems pretty good at extracting data from PDFs and Excel files etc, it will show me the correct data in the chat. BUT when I ask it to push this into a pre-existing word template it just doesnt work. The best result I had was when Copilot added the Key Data to the end of the Word doc. Not what I wanted but not a million miles off. Its also fine with putting this into a new word document. So it feels like Copilot has all the functionaility required but just wont combine this with using a pre-existing word/excel template. I even tried content control boxes. For some context, this sort of thing (basically copying pasting data from one doc to another) is incredibly time consuming and there is a LOT of this in my industry. Hoping that there is a way to achieve this, even if it means multiple steps etc! 🙃
Copilot Sparkle in Excel missing
Hello everybody, one of my collegues has a problem in Excel Desktop. He is full licensed with Copilot for M365. Everything works fine, but the little icon (known as sparkle) beside a cell in Excel is not showing up. In the browser version, everythings works as expected. In the desktop version he has to use the context menu to reach the Copilot function. This behavior occurs on 2 different installations. Any idea to solve the problem? Thanks for you help. Best regards André
Have you ever wished Excel could calculate faster — maybe even use your GPU?
I’ve run into performance walls with large Excel spreadsheets — especially ones with complex formulas or large datasets. For example, dealing with time series of market data where they don't all have the same set of holidays and trading days. Even with only 20 years of daily data, having more than a few tickers can make changing one cell take 30 seconds while it all recalcs. I’m wondering if others have hit similar limits. - Have you ever wished Excel could use your GPU to speed up recalculation? - What kinds of sheets or formulas caused the slowdown? - Did you find any workarounds, or just live with it? I’m looking to hear what kinds of spreadsheets people struggle with most, and tips for how they got past them if they did.
Sheet View Issues with Excel Web Browser
Hi, I have created a Excel document for my department to use, I tried Excel App but due to the size of the Spreadsheet it kept freezing, as a result I switched it to use Excel through Web Browser. The sheet no longer freezes which is good. I do have another issue though.....I wanted multiple users to be able to access, edit the sheet at the same time so I did some research and Sheet View seemed to be the way forward. I created a Sheet view for each employee to use so when you go to View, Sheet View and click on the relevant person their work is updated, saved etc and this shouldn't affect others view. This is working in terms of people editing. The main issue now though is that despite following advice sometimes when someone changes a filter on their own sheet view it seems to change others view. My understanding was you can hide, filter etc within your own Sheet view but this doesn't seem to be the case.......PLEASE HELP!!!! My excel and computer Skills aren't excellent to please any simple advise would be great.Data Reconciliation Assistance Needed – Time Range & Sum Matching
I have two sets of data that need to be reconciled. Specifically, I’m trying to identify which combinations of numbers from these datasets can sum up to a specific target value. Additionally, the reconciliation should only consider entries that fall within a defined time range—from approximately 8:00 AM on one day to 10:00 PM the following day. I’ve tried using Solver and Goal Seek, but the results don’t seem accurate. I also attempted using Microsoft Copilot, but the outcome still appears incorrect. Could you assist with identifying or generating the correct combinations based on the criteria above?People data lookups
Hi, I have created an MS Form where anyone can nominate their peers for recognition - we have 20k employees. I've added a field in the form for a unique employee number for the nominator to include. So they would submit the nominee's: emp number, full name, role, area of the business. The output comes to me in excel and I need to update a list of 00's of employees, where they work, their contact details, line manager detail etc. The challenge is this: whilst I can do all the look-ups to the external data to provide this, the output of the form could have numerous errors. First of all, a missing emp number or incorrect emp no. Second of all, incorrect name spelling, or shortened names, or duplicate names, or too many spaces etc. Then there's incorrect role or missing role, and finally the same for area of the business. Using either multiple IFs or look-ups or Power Query, what's the best solution to pull through the correct emp number (from my external data), when those first four fields could be all wrong, partly wrong, missing or all correct, and what about dealing with duplicate names? I can concatenate if the four fields are correct, but this isn't reliable. Is there a fuzzy match that takes the best guess at the four fields completed - leaving me to just check a handful of #N/As? I have Copilot and licence too. Thanks!Agent Mode continuously loading
Hi all, I installed Excel Labs today and have tried to use https://www.microsoft.com/en-us/microsoft-365/blog/2025/09/29/vibe-working-introducing-agent-mode-and-office-agent-in-microsoft-365-copilot/ for Excel in the web. However, no matter which prompt I use, it just loads continuously, even when left for hours. Has anyone got this working? Or know how to resolve this? I appreciate it's a Preview feature, so happy to wait if it's a temporary glitch, but thought it'd be worth checking.
