Data Model error
I am getting the following error in Excel. "We couldn't get data from the Data Model. Here's the error message we got: An unexpected error occurred (file 'pcminorobjcoll.inl' , line 109, function 'PCMinorObjectCollection<class PCProperty, class NameHashSupport> :: SetNameAndUpdateCollection'). I have found various articles that have suggested going through and checking the source data headings. I did this and nothing seems to be out of the ordinary. https://contexturesblog.com/archives/2020/03/26/excel-pivot-table-refresh-error-with-data-model/ Is there anyone that can help me? The document is fairly large and used frequently by staff. I'd like to avoid recreating it, or tearing it apart. If possible.
New ways to customize how Copilot edits your workbooks
If you’ve ever typed the same formatting and style instructions into your Copilot prompt every single time - don’t merge cells,” “use my header style,” “name the tables this way”- we built two new features for you! These new customization options let you set your rules once and have Copilot follow them automatically. Personalization is now generally available, and workbook rules are rolling out to general availability across Excel for Web, Windows, and Mac. Personalization: your rules that follow you Personalization lets you tell Copilot your standing preferences once, and it follows them across every workbook you touch. No more repeating yourself. Copilot learns your preferences before it starts editing, so the output always reflects the guidance you provide. Set preferences for things like: Formatting: “Never merge cells.” “Don’t use red in charts.” “Always format currency in USD with no decimals.” Naming conventions: “Name tables with a tbl prefix.” “Use clear, descriptive sheet names.” Formulas: “Write formulas with structured table references, not cell ranges.” PivotTables & report styles: “Default to my standard summary layout with bold headers and subtotals.” How to access it Open Copilot in Excel. Open Settings (...) → Personalization. Add your preferences in natural language and save. Copilot applies them every time you prompt it. Workbook rules: standards that follow the workbook Where Personalization is about you, workbook rules are about a specific workbook. Rules live in the workbook and travel with it when you share it, so teams and organizations can standardize how a file should look and behave, and everyone who uses Copilot to edit it stays consistent. These rules are stored in the workbook as a sheet with the “.Rules” naming convention, which signals to Copilot that they should be followed for all edits made in the workbook, regardless of the user. What makes workbook rules especially powerful is the ability to tap into Excel’s calculation engine, giving you a low-barrier way to leverage the Excel functionality you already know how to use. Unique ways to leverage workbook rules: Point to an exact example: Format a sample range exactly how you want it, then tell Copilot “match this formatting”—an exact example beats a written description. Make rules dynamic with formulas: Reference cells, ranges, or other sheets so rules can change based on what’s already in the workbook. For example, applying one instruction when a project is over budget and another when it is on track. Use Copilot to build and edit the rules sheet: Start from a blank .Rules sheet or an existing template, then ask Copilot to draft, refine, or update the rules. Aim it at an existing, well-built example sheet and ask it to infer the rules automatically for a fast way to standardize an established template. Share for consistency: Because the rules are stored in the workbook, every collaborator and every future version stays on-standard. Share rules sheets with others to bring into their own workbooks for consistency. How to access it Open Copilot in Excel. Open + → Create workbook rules. This creates a new template. Add rules in plain language, point to an example range, or ask Copilot to generate rules from a sample sheet. Rules must be in column A of the sheet, but can reference other areas of the sheet (e.g. example of a formatted table of range). Note: If you have an existing sheet you'd like to leverage, simply rename the sheet with ".Rules" and start adding your rules in column A. Try it today: Personalization is available to all Copilot in Excel users on Excel for Web, Windows, and Mac. Learn more about Copilot in Excel personalization. Workbook rules is available in the Insiders channel for Windows and Mac and rolling out to general availability in the coming weeks. Learn more about Copilot in Excel workbook rules.
CountIFS/SumIFS Question
Hello everyone, I'm working with a lot of data, and trying to find a way to add quantities already in the sheets but spread out over 500 or more rows. I'm not able to change how the data is delivered to me, as it's a downloaded file from a 3rd party. Here's a sample of what I'm looking at: A B C D Plain Bagel 7 Plain Bagel Bagel Spreads Cream Cheese 5 Plain Bagel Bagel Spreads Butter 2 Plain Bagel Toasted/Warmed Yes Toasted/Warmed 7 Double Espresso Food Selection Plain Bagel w/ Cream Cheese 4 Hot Chai Latte Food Selection Plain Bagel w/ No Spread 2 Iced Coffee Food Selection Plain Bagel w/ Butter 6 Basically, I'm trying to add the numbers in column "D," but only if these requirements are met: If column A says Plain Bagel, column's B and C have to be empty. If column C has any type of Plain Bagel, then those should also be added. In case it's needed: I'm currently using Excel for the web, but I do have access to the desktop version as well.
Macros blocked in shared OneDrive Excel workbook as untrusted source
I have a macro-enabled Excel workbook (.xlsm) stored in OneDrive and shared with another user. When they open the shared workbook in Excel Desktop, they receive the error: "Microsoft has blocked macros from running because the source of this file is untrusted." We've already tried enabling macros in Trust Center, adding Trusted Locations, and opening the file from a synced OneDrive folder rather than Excel Online, but the error persists. Since downloading the file creates a separate copy and defeats the purpose of a shared workbook, what is the correct way to allow VBA macros to run in a shared OneDrive-hosted workbook while keeping everyone working from the same file?
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.
Excel TEXTBEFORE function went away and gives #NAME? error
Hi all, I had an Excel sheet working using Office 2019 on a Windows 11 machine using the TEXTBEFORE function. Now after the latest Windows update, the function seems to have disappeared from excel? I now see #NAME? errors, and its not an option for selecting when adding a new function to a cell. The functions were also auto-replaced with a new prefix: ``` =_xlfn.TEXTBEFORE(L241, " ") ``` I'm on Excel Version 2410 Tried to add the build number, but I get an error on publishing saying "##.#.#### is not allowed in the community" Anybody else seen this or have any ideas on what's happening?
