Forum Widgets
Latest Discussions
Excel 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?
Version 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?
Excel 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!
Online 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.
Combine 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, Iulian
Pulling 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 youDate 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.
STOCKHISTORY 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):
