excel
44944 TopicsMacros 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?33Views0likes1CommentMacros in Excel Programs
I am developing a macro enabled spreadsheet that creates a second macro enabled spreadsheet upon exit. Is there a way for the macro in my main spreadsheet to create UserForms and Modules in the second spreadsheet? My goal here is to distribute the second spreadsheet to users and their use of it will be controlled by the UserForms and macros within it.30Views0likes1CommentCountIFS/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.77Views0likes2CommentsExcel Macro Creating a New Macro Enabled Spreadsheet
I have a macro enabled spreadsheet. I have a macro in this spreadsheet that is trying to create another macro enabled spreadsheet. I can create this new spreadsheet and save it as a .xlsm file. However, I want to give this spreadsheet a name and transfer data to it by toggling between my two sheets (Windows(Filename).Activate) and not save it until I am done. My problem is that the only way I have found to name it is with SaveAs statement. If I could find out what name Excel assigned to this workbood when I created it, I could work with it - but I have not found a way to do that. If the above is confusing, I am sorry. In simple terms, I want my macro to create another macro enabled spreadsheet, name it, work with it and Save it without using SaveAs. I can provide code, but I thought I would start with this.Solved37Views0likes2CommentsExcel 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?943Views0likes4CommentsSorting dataentries but keeping separation between subheadings
Hello! I would like to sort datasets with three columns, but keep the sets separate with different subheadings, but sort them all within themselves. I find it difficult to explain further with words but will attach images. In the first images the datasets are shown as entered and by default are sorted by the leftmost column, as that's how they're entered. I would however like to be able to sort by the right most column, but keep all the datasets separate. I have made a mockup in the second picture to show what I mean. Is this possible? Thank you in advance!81Views0likes2CommentsWelcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team65KViews30likes97Comments