Forum Widgets
Latest Discussions
I want to use Ctrl+Shift+Enter in Excel 365.
In Excel 365, I want to enter an array constant using Ctrl+Shift+Enter. But it doesn't work. Since I’m preparing for a certification, I need to enter the array constant using Ctrl+Shift+Enter so that it is recognized as the correct answer. Please help me!😭planilha excel corrompida
boa tarde, atualmente uso uma planilha em excel no meu notebook que a mesma é compartilhada no google drive, porém ao realizar a ultima modificação e ao tentar abrir ela no dia 08/09 o arquivo nao esta abrindo, aparece a mensagem erro de arquivo ou extenção verifique, estranho que ao clicar em propriedades ela aparece como 0 bites. OBS NÃO É POSSIVEL ABRIR ARQUIVO
Webservice function
Hello. I want to use the WEBSERVICE function to geolocate an IP address. The address is in cell A1, and the function is in A2. The function looks like this: =WEBSERVICE("https://ip-api.com/csv/" & A1). Unfortunately, the result is #ARG!. I have no idea what is wrong. Can you help me? Best regards, Piotr
Linked data not updating
Hi I have a rostering spreadsheet where each person has their own spreadsheet with their rota they select a shift in their spreadhseet. I have a main spreadhseet where I link each spreadhseet to my my main rota so I can see what shifts they have selecteeneed and be able to resolve any conflicts i.e 2 peole selecting sam eshift. The issue is when data is updated in the individual spreadhseet it is not pulling through to my main spreadsheet. I used Data and get data form Excel file to link the workbooks. Not sure what I am doing wrong When Dr Adams adds a Y in Thursday it is not showing in my spreadhseetBigSpill: A 92‑Function Excel LAMBDA Library for Dynamic Arrays
What is BigSpill? BigSpill is an Excel LAMBDA library containing 92 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: BigSpillPlease Help_ Disappeared Excel Doc
Dear Expert, I just lost my Excel Document that improved after I have downloaded from the Chat GPT. I have improve many different sheets on the documents but it is now only see the excel sheets that I made yesterday. I can only see the last page I improved today. Please help me.
