Forum Widgets
Latest Discussions
Excel 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.
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?
Sorting 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!Welcome 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 Team
Automatically resizing and moving workbooks.
Hello, When I am juggling several documents on my monitor screen, the darned windows for excell or word will automatically resize and move off to the side. The new size doesn't leave a place to grab and move it back. I basically have to close down and start over. Very exasperating. How do I turn it off and just move things around as I want?
LAMBDA : function generating #NAME error
Hie, I juste discovered Lambda function, and i have a problem. I created a lambda function that compute a cubiqual polynomial with the code : Poly3:=LAMBDA(_a, _b, _c, _d, _x, ((_a*_x+_b)*_x+_c)*_x+_d) Excel accepte de function, but when putting the function in a cell, it generate a #NAME error. I Debug the Cell, and it seems that de fith argument is refused, with #NAME error ! but the data pasted to the function is a basic computed value ! I don't see anithing rong in my function. Does anyone have an idear, or explaine me what rong in this code ?
Problem: Excel opened the first file quickly, but the second and subsequent files very slowly
Problem: Excel opened the first file quickly, but the second and subsequent files opened very slowly when launched externally (double click from Explorer or using excel.exe "file.xlsx"). Environment: Windows 11 Pro 25H2 Office 2021 Pro Plus Clean Windows installation Clean Office installation Modern hardware (Intel 13th gen + NVIDIA RTX) Symptoms: First Excel file opened fast Second and subsequent files became progressively slower Opening files from inside Excel was always fast Drag & drop from Explorer into an existing Excel window was fast Word did NOT have the problem Reinstalling Office did not solve it Disabling Defender, Protected View, StartAllBack etc. did not solve it Cause: Registry DDE handler related to Excel shell open behavior. Registry key: HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec The (Default) value was empty. Fix: Set (Default) to: [open("%1")] Then reboot Windows. After that: multiple Explorer launches became instant again no more progressive slowdown Excel external opening worked normally again Important note: On other healthy machines the value may still appear empty, so the fix may actually force Windows/Excel to rebuild or refresh the COM/DDE association/cache rather than the value itself being universally required.
