Pinned Posts
Forum Widgets
Latest Discussions
REGEX+TEXTSPLIT
Dear Experts, I have a data like below in column"A":- And , I want to split it in the way like in "Yellow" So, after each consecutive Alphabet or number it should be splitted, I tried to do something in Column "B" but not succesful. Could you please share any solution if possible by using a comb of regex + textsplit? Thanks in Advance, Br, Anupam
Excel dominance
For many years I have been using Apache Software's Open Office spreadsheets (".ods"). When I opened one today, Excel in Read-Only mode appeared. It said that to add to or edit the existing content, I would have to purchase Microsoft 365. That is "restricting competition" in law. I do not know how this has happened. How can I delete the Excel program permanently because it reappears when I reboot my computer?
POWER QUERY NOT WORKING !!
I’m using Office LTSC 2024, In Power Query, when I try to load data from another Excel file (or even the same workbook), I get the error: "Microsoft Excel couldn't load a necessary component. It might have been damaged or deleted. Try reinstalling the client software or data source driver software for your database." And also: "download failed error in data source query n connections". Here’s what I’ve already tried: Tested with a new blank workbook, same error appears. Done Office repair (both offline and online), still not working. The issue is only with Power Query loading Excel workbooks. Could anyone please help me with this issue?
Is the Excel Review -> Optimise feature available through Microsoft.Office.Interop.Excel
Hello Excel community, We have a client with a large collection of Workbooks that they copy every year to produce the next 'generation' of workbooks. Many of these workbooks are overweight with respect to file size, and performance. Is it possible, using dotnet and the Excel Interop COM objects to invoke the Optimise wizard that is available in the Excel user interface? Review -> Performance -> Optimize all
