Forum Widgets
Latest Discussions
Excel Query
Hi everyone, Yellow highlighted column enteries are added manually. I want to insert a formula which will automatically write 1 in column "Q" for unique enteries against column "C" and then write 2 in Column "Q" for next unique entry in column "C". Can somebody please help?ExcelGeek90Jul 18, 2025Copper Contributor23Views0likes4CommentsExcel Query
Reposting since I did a typo in last post. Hi everyone, Yellow highlighted column enteries are added manually. I want to insert a formula which will automatically write 1 in column "P" for unique enteries against column "C" and then write 2 in Column "P" for next unique entry in column "C". Can somebody please help?ExcelGeek90Jul 18, 2025Copper Contributor3Views0likes0CommentsVersion History Empty
I use to use the feature https://support.microsoft.com/pt-br/office/restaurar-uma-vers%C3%A3o-anterior-de-um-arquivo-do-excel-89c09b39-8f01-456e-82be-5d89f371436a to recover old versions of my files. But today, when I went to recover a June 30th version of an Excel file, the versions table is empty. Is there any other way to recover old versions? This empty table is an application bug?MC11Jul 18, 2025Copper Contributor55Views0likes5CommentsExcel Not Refreshing Data from Power BI Semantic Model (Live Connection via XLMA)
Hi everyone, I'm trying to create a fully automated reporting process by connecting an Excel workbook directly to a Power BI semantic model using the XLMA endpoint (live connection). The goal is to have Excel always reflect the latest data from Power BI, without needing to manually export reports or paste tables. I’ve written a script that opens and refreshes the Excel workbook each morning to ensure everything stays up to date. The problem: Even after running the refresh (via script or manually in Excel), the data doesn't actually update. It continues to show outdated values, even though Excel successfully connects to the latest version of the semantic model in Power BI. I've already confirmed with my Power BI team that the semantic model is working correctly and refreshing as expected. Their suggestion is that it's an Excel-side issue. Details: I'm using Excel for desktop (latest version) with a Power BI Pro license. The data is pulled via "Get Data, From Analysis Services" using the workspace connection URL. There are no errors during refresh, but the values don't update. Later on, I sometimes do get error messages but not always and never during the initial refresh. The message is along the lines of: "We couldn’t get data from the external data source. The (blank) session ID cannot be found. Either the session does not exist or has already expired." If I manually rebuild the pivot table, it does pull the correct current data, but that defeats the purpose of automation. Has anyone encountered this issue? Is there a known limitation or workaround for ensuring Excel truly refreshes the live connection to the semantic model? Appreciate any insight or suggestions! Has anyone encountered this issue? Is there a known limitation or workaround for ensuring Excel truly refreshes the live connection to the semantic model? Appreciate any insight or suggestions!michaelwolfinger0710Jul 18, 2025Occasional Reader49Views0likes2CommentsOnline Word Doc Problem
Hi. Recently I noticed my online word doc in Edge is displaying in Russian, despite all settings everywhere are English. I restarted Edge, laptop, Word docs etc. Nothing changing this issue and nowhere Russian to be found in settings. What can I do to change it? I am using a work laptop, so a lot of settings are not available as my laptop is managed by my organisation. Please help, this is frustrating! I tried everting, googled all answers and possible questions. Nothing helps.DashaCJul 17, 2025Copper Contributor41Views0likes4CommentsUnable to Protect Worksheet
Hello, I locked my cells and added a password to protect my worksheet but I am still able to edit. The only thing users are allowed to do is 1) select locked cells and 2) select unlocked cells. Protecting the worksheet didn't work. What am I doing wrong?jayelJul 17, 2025Occasional Reader31Views0likes1CommentCombine table name with each value in the first column
Hello, I need a little help in Excel. So I have some tables of the following structure scattered across multiple sheets. (Fake data) Nokia Phone model Color 6610i Blue 3310 Yellow I want to gather all the data from every sheet into the following table Manufacturer Model Color Nokia 6610i Blue Nokia 3310 Yellow OnePlus 8 Pro Ultramarine Blue The data table always start on column A. Thanks, Iulian104Views0likes6CommentsPulling out only last names from a list containing two and three word names
I have a question regarding TEXTSPLIT I'm dealing with a spreadsheet with a list of names in column A, some of which have only a first and last name, and some have a middle name as well. John Smith Eric Trevor Madison I need to pull out only the last names from each entry in column A and enter it into column B. How can I do this. Thank youAlifJul 17, 2025Copper Contributor33Views0likes1CommentDate not showing slash(/) symbol
Hi everyone, I'm currently using excel from office 365 lifetime version installed in pc. It seems that when I type a date, for example 01/01/2020, it will register as '1 01 2020'. I have already tried deleting Microsoft office registy then reinstalling. Any suggestions on how to fix this so that it will show '01/01/2020' Screenshot below.SolvedjlapidoJul 17, 2025Copper Contributor19KViews1like5CommentsSTOCKHISTORY values don't match with actual data
I've been analysing some sheets I've built using STOCKHISTORY (portuguese version HISTÓRICODEAÇÕES) and comparing with actual data (from Google Finance). I've realized that the values are not matching, and they diverge differently over time depending on the stock, always increasing over time. What's going on? For instance, CMIG4 (BVMF):RicardoBFischerJul 17, 2025Copper Contributor30Views0likes1Comment
Resources
Tags
- excel42,929 Topics
- Formulas and Functions24,904 Topics
- Macros and VBA6,452 Topics
- office 3656,105 Topics
- Excel on Mac2,666 Topics
- BI & Data Analysis2,406 Topics
- Excel for web1,944 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,658 Topics