Hi letstalkityt, Before we go on, could you please be a bit more explicit about what you mean by "Powerview is available but not working"? ... Excel 2007 : Find & Replace can't find text in formulas. Comments Closed. I want to be able to create a map ONLY of my data points in the US and no surrounding countries, water, continents, etc. It works fine when the source data and drop down list are on the same sheet, but its not updating when the source data and drop down list are on different sheets I always have to go to the Options button to specify that it should look in Values. As of late July 2020, you need a subscription version of Excel to get dynamic arrays. Please Login or Register to view this content. 03-15-2018, 04:15 PM #10. Is it available in the COM Add-ins list? I only have icon for 3D Map and not the map chart icon. User question: The Excel Find and Replace dialog drives me crazy. Adrian. Excel 2016 Posts 192. Drop down list not working Hi, I have a drop down list which is auto updating from a table. I am trying to create a map chart (not 3D Map) in Excel. Register To Reply. For the time being, you can’t find the SEQUENCE function because your version of Excel doesn’t support the new dynamic arrays feature. Excel 2016 Mac & PC & 365 Posts 621. May 8, 2015 Mar 2, 2020. I have a sheet with a list of names on and I've noticed that when I use ctrl+F to use the find function, even when I know i have entered the correct name it still will not work. [FIXED] Excel cursor flickers after updating to Windows 10 Fall Creators Update (v1709) [FIXED] Unable to copy or move sheet in Excel 2016 (Build 4229.1002) [FIXED] CTRL + H or Replace button opens the Find tab on the Find and Replace dialog in Excel 2016 In that case, I could do the find and replace, but when I switched it back, it could not find the string. Uncategorised If you are using the Find function in Excel (CTRL F or else in the HOME ribbon under Find & Select) you may get frustrated when it appears that the Excel find is not working. AutoFill handle for Excel 2016 doesn't work Intermittently I've been running into issues where the auto fill handle will just stop working on my Excel sheets. In the figure below, the mouse pointer is showing the value that Excel says is not actually there. Excel find not working. It did not make the string. When you mouse over the bottom right corner of the cell, the handle changes to the proper black plus sign looking one.