windows 10

Hello, so I'm using Microsoft Excel on Office 365 and I'm using the VLOOKUP function and having some issues. Here is the current state of my formula I'm trying to troubleshoot: =VLOOKUP(C3&"*",A:B,2,FALSE) Column A is filled with identification keys composed of letters and numbers while column...

Hello there! I'm sorry to bother you all, but I've been having trouble for about a week now on how to make this work in Excel 2016 and couldnt find a solution yet... Here's what we got: There's a lobby where people going in and out, in the left group of columns. We got exact time of their...

Hey everyone, I don't use Excel a lot, so I am quite proud with what I have come up with. Wish I could share it but it has all my financial data and crypto holdings to create a dashboard. Power queries, just trying to solve a different issue at the moment with VBA, the lot! Besides the...

Hi, I have one destination workbook open on PC#1 (Windows 10) The workbook has links to two source workbooks open on two networked (wifi) laptops (Windows 10) PC#2 and PC#3. I'm using the current version of Excel 365 (on all three computers). For the cells of the destination workbook to be...

Can someone help me please. As you can see in cells B17 and C17 I have a size with a ± value of 0.30 and column D is for the lowest size(110.50 - 0.30) and Column E is for the highest size(110.50 + 0.30). The formula that I am using works perfectly but that is only if there is ± but sometimes...

Hi, This is my first post please be nice. I am creating a Windows 10 Excel 2016 document which takes a bulk data download on Tab 1 (5 rows, 70,000+ column entries), filters out around 10 words, filters in around 15 words (Keywords are Tab 2) and displays the filtered data (Tab 3) as 5 columns...

Hi Friends, I tried looking mrexcel posts and google sources for query to find VBA answer. Here what I am looking for is: Sheet1 ColumnA has data of boolean strings like attached in the document. The row numbers varies every time whenever I change the data. Boolean example has shown in image...

Good morning, Since upgrading to Windows 10 from Windows 7, my automated reports are not working. They run via Task Scheduler that simply opens the workbooks which call the associated Macros upon opening using the Workbook_Open option. They used to open, run, copy a range of cells, send an...

I'm new to VBA in excel and I borrowed this code from a previous thread that has worked well. It takes each value from column B in my main tab and creates a named tab with the format of the CONTROL tab and hyperlinks it in the original tab. My problem is that each tab, although correctly named...

Hello, everyone, I have a pivot table displaying the total sales of three brands in two columns (one as currency, the other as % of total). The currency column's numbers are formatted as currency, with thousands separator, two decimal places and "лв." after each number. For each of the three...

I run Win10 Pro on a Thinkpad. The size and position of opened, then closed Excel-windows is not preserved between Windows-sessions. This is true for other windows as well, e. g. Edge. They reopen at any position and/or any size. Is there a setting to keep positions and sizes like in former...

I have a hyperlink and I want to view all photos in a folder I've tried =HYPERLINK("d:\pics\Prob\*", "photo ") =HYPERLINK("d:\pics\Prob\*.jpg", "photo ") =HYPERLINK("d:\pics\Prob\firstpic.jpg", "photo ") The first two say can't open specified file The last one works and opens the picture in...

Hi I've just upgraded to Windows 10 and I'm now trying to open password protected files that were created with 2007 but when I open the file Excel pops up but the password box doesn't so I can't get into it. It's a file created by head office so I have to leave the password in place. Do you...

I am running windows 10 and when i am in another program (it doesn't matter what program), excel decides to open. There is no pattern of what is running on my computer, or any timing. It may start up in the middle of a game, or any other application. I can shut it down and it may start again...

Hello everyone. I currently run a VBA Macro that can take several hours. Previously I have never had a problem but I have just updated to Windows 10, and now when I come back to my PC I find that Excel has crashed and I am presented with recovery files. It seems that W10 is doing something...

Until recently, I have been using Excel 2003 on a Windows 10 platform, but after a Windows 10 update the program Excel program shuts down whenever I try to enter data, notably when the cell contains a formula. I have unintstalled and then reinstalled the Excel 2003 but that didn't cure the...

I using VBA / Excel (MICROSOFT OFFICE PROFESSIONAL PLUS 2016) / W10 Pro. I have been using some code (my own) for a while to copy and paste some MT4 code (for Metatrader 4 Forex platform - C++ like code) from a textbox and into my MT4 environment. The code I require is correct and it pastes...

Hello, My firm uses a number of macros to send excel files to business partners via outlook. This works wonderfully on Win 7 computers. We recently started deploying Windows 10 PCs, and we're getting error 429 on the following line: Set OutApp = CreateObject("Outlook.Application") The full...

I'm completely clueless here! I do have some code to run the app from Excel and then user can use camera regularly, but how to save taken picture directly into Sheet? Sub RunCam() Dim SHRTCT As String Dim RNCMD As String SHRTCT = "C:\Users\Public\Desktop\yyyy.lnk" RNCMD = "RunDLL32.EXE...

Hello, I have problem with freezing/unfreezing panes in a specific workbook in excel 2013, windows 10. The workbook and worksheets are protected and contain VBA code. I can freeze and unfreeze panes in excel 2010 windows 7, after unprotecting the workbook. In 2013 button to freeze panes in...