Excel "You don't have permission to use this add-in"
Microsoft 365 Personal subscription Excel Version 2608 (Build 20326.20144) Add-ins work in Excel for the web Add-ins fail only in desktop Excel when signed in Issue occurs on two different Windows PCs Add-ins become available when Office is signed out Connected Experiences enabled No Office/Cloud policies configured Office add-in cache and identity cache already cleared
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.Remove a comma from a number treated as text
Greetings! I'm new to this forum, and I don't know if this is the right place to ask. But, here it goes: I have a column of currency values which is a mess. I managed to clean it as much as possible using the functions SUBSTITUTE and TRIM. These functions transformed the unformated numbers into text, and now it looks something like this: 6,764,68 1,319 1,948 301,40 2848,08 The former is a sample from 165 entries. Is it possible to remove the first comma of the string, so the values look like this instead? 6764,68 1319,00 1948,00 301,40 2848,08 What I would like to do is to remove the second comma from right to left in each value, while keeping the first which marks the cents of the transaction. Can this be done? Thanks all in advance :DFilter selected columns in a specific order
Hi All, If my source data contains 6 columns: A B C D E F and I want to FILTER 3 columns with the order being A F D (i.e. not in the same sequence as the source) It does seem to work. I am suing the formula FILTER(Source, Countif(HeaderRow,SourceHeaderRow)) where SourceHeaderRow is ABCDEF and Header row is AFD In other words, it seems to me that the FIltered data must be in the same sequence as the source data. Can this be done. Please note that I do not have access to CHOOSECOLUMN function. I hope this makes sense! thank you in anticipation. PeterBigSpill: A 97‑Function Excel LAMBDA Library for Dynamic Arrays
What is BigSpill? BigSpill is an Excel LAMBDA library containing 97 functions across 10 categories, built from extensive experimentation with dynamic arrays. The goal is to provide elegant, efficient tools that make sheet‑level formulas easier to read, more modular, and more dynamic. The library includes a mix of: quality‑of‑life helpers essential primitives mid‑level operators developer‑level tools a few functions you might not expect to see in Excel Who is it for? Everyone. BigSpill aims to make complex operations more approachable and expressive. A few examples from the library: Pairwiseλ Staircaseλ Grainλ PolarGridλ Convolveλ Foldλ Tessellateλ Revealλ Knapsackλ Magnifyλ Traverseλ The repository includes full documentation and 11 sample workbooks so you can explore the functions without setup. If you’re interested in experimenting with dynamic arrays, or LAMBDA workflows, feel free to take a look. Feedback and suggestions are always welcome. I've attached 1 onboarding workbook. There are 10 more at the link below. GitHub: BigSpill
