Recent Discussions
Conditional Formula?
I'm trying to make a conditional formula where if the logical test (=if(logical test) results in a number in another cell being greater the value of the formula cell returns a value with a color. Is this at all possible? i.e. if the value is higher the color is green if not the color is red
Runt-time Error 1401 When Importing a CSV file Using VBA
I am beyond frustrated that I cannot make this work. Let me explain. My spreadsheet needs to import a standard CSV file then parse that information into several different worksheets. The very first time I ran the import code it worked. The second time and every time after that it fails with the "Run-time error '1004': Application-defined or object-defined error" message. I tried this on a different computer with the same results first run it worked, every run after that it fails. Here is the code: Sub ImportCSV() Dim ws As Worksheet Dim csvFilePath As String Dim lastRow As Long ' Set the worksheet where you want to load the data Set ws = ActiveWorkbook.Sheets("Raw") ' Specify the path to your CSV file csvFilePath = "exportusers-all.csv" ' Clear existing data in the worksheet ws.Cells.Clear ' Import the CSV file With ws.QueryTables.Add(Connection:="TEXT;" & csvFilePath, Destination:=ws.Range("A1")) .TextFileParseType = xlDelimited .TextFileCommaDelimiter = True .Refresh End With End Sub This is the code I've found in numerous places when I search the internet when I search how to do it. I have tried this as a normal user and "Run as Administrator" both fail. My Trust Center > Macro Settings are as follows: Enable VBA macros - Selected Trust access to the VBA project object model - Checked The CSV file can be opened in a text editor and Excel without any issues, but if I try to import it, it fails completely. Any help or suggestions to resolve this problem would be greatly appreciated. Thanks.
Using Mail Merge with MACROS
Hello, I am currently trying to use Mail Merge from EXCEL with a WORD document to be emailed in OUTLOOK The emailed document takes the form of a .pdf attachment Our designer has created a Customer Order Update document that requires a WORD MACRO to realise his formatting once the Merge has taken place. I have created a MACRO in the WORD document that is able to perform the correct formatting on the WORD document after the merge with EXCEL spreasheet data has taken place. However, with a multiple page document I find that the MACRO is only applied to the 1st page of the document Subsequent pages of the generated .pdf do NOT have the MACRO applied ( I have various detail lines that are hash preceded capital letters that trigger the MACRO to perform a subtitle substitution ) As the MACRO goes through 25 lines of detail (below the fixed document header) in a Loop to perform substitutions I wondered if expanding the Loop to 50 lines would allow the second page of the document to also receive the MACRO processing. This did NOT happen Please advise how I can get the MACRO to apply to every page of the mail merged document I do not believe that the MACRO can only be applied once to the 1st page of the mail mereged document only regards
Fixing Hyperlinks in a Copied Worksheet (on an Apple Mac)
I have scoured this forum’s discussions about hyperlinks in a copied worksheet referencing back to the original sheet. Perhaps I missed it, but I didn’t find a solution to my specific problem, so I will start a new discussion. Apologies if a community wizard already answered it. I have a workbook with monthly worksheets, each showing the transactions into and out of a savings account. Each transaction goes into (and out of) one of several “virtual” accounts to reflect the purpose for which the money is earmarked, like property taxes, travel, etc. (called Account 1, Account 2, and so on in the attached) Each month’s worksheet has a section of hyperlinks, each of which ideally jumps to a specific account in the same worksheet. The attached example contains only four accounts, but my actual one has 23 with 31 columns and 98 rows. So the hyperlinks are helpful in navigation. Each month, I make a copy of the latest worksheet and rename it for the new month. The problem: the hyperlinks in the new, copied worksheet reference back to the “source” worksheet. With 23 hyperlinks, changing each one’s sheet reference (Edit Hyperlink...) every month is not efficient. Question: how can I (efficiently) make the hyperlinks in the new worksheet reference cells in their new worksheet? These are hyperlinks that are internal to the workbook, not to external URLs, so DonBici’s Feb 21, 2024 suggestion of a helper column doesn’t seem like it would work in this case, and I am not advanced enough for his VBA suggestion. Thanks!
Microsoft Word - Footnote remains on the original page after moving the original reference up
Issue I encountered an issue in Microsoft Word where moving the original footnote reference to an earlier location in the document did not move the footnote itself. The footnote remained on its original page even though the reference had been moved. This was particularly problematic because the same footnote was referenced multiple times throughout the document using cross-references. Cause The footnote is anchored to the original footnote reference in the main text. In my case, Word had somehow lost track of that original anchor, so the footnote stayed on its original page while all cross-references continued to point to it. Solution Hold Ctrl and click the misplaced footnote reference. Word jumps to the original footnote reference in the main text. Cut the original footnote reference (Ctrl+X). Paste it in the correct location using Keep Source Formatting. Press Ctrl+A, then F9 to update all fields. Verify that: the footnote has moved to the correct page, the numbering has updated correctly, all cross-references still work. In my document, one footnote had previously lost its connection to the original reference, so its numbering did not update automatically. That one had to be repaired manually. Important Do not create a new footnote or copy the footnote text itself. Move the original footnote reference in the main text. This preserves the existing footnote, its numbering, and every cross-reference that points to it. I hope this helps someone else. It took me quite a while to figure out what was happening.Microsoft 365 Data Protection- TrackingID#2607020040005775 - HELP
Hello Microsoft 365 Data Protection I don't know what else to do some I am posting on the forum, Microsoft 365 Data Protection is not replying to my emails and the phone system is not working when I call (0)800 167 344. 8 Days no support from Microsoft 365 Data Protection - TrackingID#2607020040005775. Cant login to Admin Centre, the MFA is not working.... Need helpFormula challenge: re-shape and cleanup
You're tasked with re-shaping and cleaning up the fictional Faber College alumni list to be used for a mail merge. Going from this: To this: To spice things up, the First and Last names must be in separate columns. Additionally, bellman records must not be included in your list (They've been contacted already). The rules are simple: The solution must be a formula. VBA, PowerQuery, helper columns, fill handle - not allowed. I've included my solution. I believe the best solutions for this exercise will involve some of the newest functions currently available on the Beta channel. I'm looking forward to seeing some creativity. Have at it!My Microsoft Form is not able to sync to an Excel file
Hi, I am having trouble as when I try to open the results of a form that I made into an Excel is giving me the following error "It wasn't possible to open Excel online, You can still download a copy to visualize the responses on Excel" (translated from my native language so the message might be a bit different). I am able to download the form as an excel but I cannot open a website version of it, this form was made using a personal email address and Microsoft account. I cannot share the link to the forms as it has personal information that would not be allowed to share in a public setting.
Question about the excel spreadsheet row limit
Hi, I'm having trouble understanding what is meant by the excel worksheet/workbook row limit of 1,048,576 rows. Does this mean that Excel cannot display a greater number of rows or that it cannot store data for more than than 1,048,576 rows? For example, if I combine various datasets and write this combined dataset to an excel spreadsheet file, and this dataset contains 2 million rows and 20 columns, will the excel spreadsheet contain all 2 million rows and the data contained in each of them? Not being able to view all 2 million rows in Excel is not an issue; I just want to be sure that no data is being lost. Thank you!Microsoft to Stop Providing Telephony-Based Authentication Methods for MFA in February 2027
In an important announcement for all tenants, Microsoft revealed that Entra ID will no longer provide SMS one-time codes or voice calls for MFA challenges after February 1, 2027. Tenants can continue to use telephony-based authentication methods after that date, but only by purchasing a service from a telecom provider. This is arguably the biggest change in Entra ID authentication since mandatory MFA for administrative interfaces – and we have a PowerShell script to help identify the affected accounts. https://office365itpros.com/2026/07/14/entra-sms-one-time-code/
Vaihdoit uuteen puhelimeen. Authenticator ongelma
Vaihdoit uuteen puhelimeen. Microsoft Authenticator ei ole enää saatavilla vanhalla laitteellasi. Et voi kirjautua Microsoft 365 -työtilillesi, koska MFA-vahvistus vaaditaan. Sinulla ei ole pääsyä mihinkään vaihtoehtoiseen todennusmenetelmään. Tarvitset apua suomeksi, jos mahdollista.How do I get balloon commenting on the right side of the page?
I'm using Word 2024 because I don't want AI in my interface. Now commenting all appears in the tab side bar. I can click on the "Comment" pulldown in the ribbon to show comments properly, but I can't write in them. This is aggressively hostile to people with vision difficulties. Even with my glasses, that's much smaller than I'm comfortable with. How can I get the comments that were so good and useful back? If not, how can I change the type size in the sidebar so I can read and write comments? Microsoft, please, don't ruin your products because you want to make us use AI for things that it's not helpful for. I don't use Word for anything I want AI in and deal with documents I cannot legally allow to be exposed to unverified servers like AI chatbots.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 TeamSharePoint 2013 to 2026: Why Legacy Migrations Are Still the Backbone of IT
Technology moves fast, but enterprise systems rarely do. While organizations eagerly adopt cloud platforms, AI-powered tools, and modern collaboration solutions, many still rely on legacy systems that have quietly supported business operations for years. One of the most common examples is SharePoint 2013. https://dellenny.com/sharepoint-2013-to-2026-why-legacy-migrations-are-still-the-backbone-of-it/User agent : ODMTADemand-Transform_Zip
Hello guys, I’m investigating a SharePoint/OneDrive alert and noticed the following user agent: """ODMTADemand-Transform_Zip""" I found information about OneDriveMpc-Transform_Zip/1.0 being related to ZIP downloads from SharePoint/OneDrive, but I can’t find anything specific about ODMTADemand-Transform_Zip. Does anyone know what this user agent is used for? Is it a legitimate Microsoft backend process, and is it related to ZIP generation/download operations in SharePoint or OneDrive?
Recent Blogs
- SharePoint Online is introducing a new tenant-level setting that allows organizations to choose whether heading permalinks should appear on SharePoint pages.Jul 14, 2026
- 2 MIN READPowerPoint is getting easier to use with new SmartArt, fresh themes, a cleaner Design ribbon, and a more modern file open experience.Jul 13, 2026
