How to get form submissions from my website automatically into Excel?
Hi everyone, I have a contact form on my WordPress https://chimneysolutionsplano.com/ (built with Fluent Forms plugin) with fields like First Name, Last Name, Email, Phone Number, Service, Location, and Message. Right now submissions are supposed to send an email notification, but I'm not reliably getting those. Since I can easily access an Excel file from my desktop, I'd rather have the submissions go directly into a spreadsheet instead of relying on email. I looked into it a bit and found that Fluent Forms has a Google Sheets integration but only in their paid Pro version, and nothing built-in for Excel directly. I'm wondering if there's a way to do this using Power Automate or some other Microsoft tool, ideally without paying for extra plugins if possible. Has anyone set up something similar? Would appreciate any pointers on where to start. Thanks!
Excel Nested Arrays: Find the Nesting Depth of Uniform and Ragged Arrays ARRDEPTH() & ISRAGGED()
Hey everyone! I’ve been diving deep into Excel’s new nested arrays features lately, and I absolutely love the flexibility they bring to data structuring. However, managing them can get a bit tricky, so I figured I’d build some specialized tools to handle them seamlessly. Public Interfaces & Arguments =ISRAGGED(array) Argument Description Default Behavior array Target nested structure to validate. Required =ARRDEPTH(array, [is_ragged]) Argument Description Default Behavior array Target nested structure to measure. Required [is_ragged] TRUE: Scans all branches for the deepest path. FALSE: Speed test on the first path only. FALSE (Omitted) TL;DR (What makes it tick): Function Name Type What It Does ARRDEPTH Public UI Returns nesting depth. Supports deep checking or fast linear testing. ISRAGGED Public UI Structural validator. Returns TRUE if array branches have uneven nesting. ANALYZE_NESTING Hidden Core Engine Multi-process recursive parser that tracks tree structure geometries. LINEARDEPTH Hidden Utility High-speed depth checker that evaluates the first element path exclusively. You can get both functions from my GitHub Gist: https://gist.github.com/Medohh2120/9cdf939036942c9672c57ccd6de696d3
Getting error when adding Add-ins in Excel
Hi all, I have trying to install add-ins to microsoft excel using a M365 Personal Account, and i keep getting an error "Add-in Error: We couldn't connect to the '{0}' catalog server for this add-in" screenshot attached below. I have tried on both Excel Web and and on the desktop Excel app and still the same issue, I have already had a session with microsoft support and they were not able to resolve this for me and directed me to this forum, Any help will be appreciated thanks in advance.
Referencing data in my formulas from specific file names in SharePoint.
We have a company SharePoint site with multiple subfolders each containing monthly excel spreadsheets. In one of the folders, I have my master spreadsheet that where the formulas are pulling in data from the files that are being uploaded. This works when I open my master spreadsheet and one of the monthly sheets, (e.g., East-February, or West-January and then link the two cells with an = and click on the source cell. On my Master spreadsheet the formula looks something like this: ='[West-February.26.xlsb]MontlyBudget'!A1 There are about 17 different folders however and instead of opening each one and redoing this every time one in uploaded. I would rather just copy the formula on my master spreadsheet i.e. ='[East-February.26.xlsb]MontlyBudget'!A1 ='[North-February.26.xlsb]MontlyBudget'!A1 ='[South-February.26.xlsb]MontlyBudget'!A1 etc. Ideally when the North area uploads their spreadsheet the formula just pulls in that data. What is happening is that I am copying the exact formula over to my new cell, I end up with a #REF error message and cannot seem link. 2 questions: Can I link these without opening up each spreadsheet separately and copying and pasting the link each time? Can I link these to future files that aren't yet created, e.g., Once West-December.26xlsb is uploaded, the data automatically pulls in?
What's the simplest way to make a genuinely random name selection system using Microsoft tools?
For example, suppose I have a list of participants in Excel and want to randomly select one winner without manually choosing from the list. Would you use RAND/RANDBETWEEN in Excel, Power Automate, or another Microsoft 365 approach? I'm also interested in preventing the same person from being selected twice when several winners are needed. I'd appreciate an approach that's easy for someone without much Excel or Power Automate experience to understand.I'm looking for a practical way to calculate Pakistan salary income tax in Excel.
The goal would be to enter a monthly salary and have the spreadsheet estimate the applicable tax and resulting take-home amount. Ideally, the calculation should be easy to update when the applicable tax slabs or salary-related rules change. For someone building this in Excel, would you recommend keeping the tax slabs in a separate lookup table and using formulas against that table, rather than hard-coding the rates into one large formula? I'm particularly interested in approaches that make the spreadsheet easier to maintain when tax rules change.
GLSU Excel add-in fails to load after Office update from Version 2607 to 2608
Our Excel add-in, Process Runner GLSU , fails to load after Microsoft Office updates from Version 2607 to Version 2608. This started August 17, 2026 and is actively growing in scope. Error messages: Excel: Cannot run the macro 'onLoad' VBA: System Error &H80004005 (-2147467259). Unspecified error VBA: Compile error in hidden module: ThisWorkbook Has anyone encountered similar issue with their own custom add-on. If yes, any pointers to fix it. We are seeking help on priority. Thanks, Vrushali Pawale, Sr. Manager, Insightsoftware.Excel Protected Sheet: Cells Still Editable Even Though They Aren’t in the Unlocked Range
I’m having an issue with sheet protection in Excel where certain cells remain editable even though they are not included in any of my configured Unlocked Ranges. I have sheet protection enabled and have specifically configured the following ranges as editable: A:E G:G J:J P:BE Based on that configuration, I would expect columns F, H:I, and K:O to be protected. However, the behavior is inconsistent: Column F/G is correctly locked and cannot be edited. Columns K:O can still be edited, despite not being included in any of the Unlocked Ranges. I’m trying to understand why F/G are respecting the protection as expected while K:O remain editable under seemingly the same protection configuration.
