Forum Widgets
Latest Discussions
#Connect Error in Excel for StockHistory Function
Evening, I am an O365 subscriber and am trying to set up an Excel sheet as a VAR template, and I wanted to populate my workbook with some historical data without uploading a CSV. Figured I would try out the StockHistory function. I keep getting "#connect" for my cells, and I am not sure why. I am not in developer mode, do not have any crazy add-ins, I am signed in, and connected to the internet. Do I need to be connected to a source? I am fairly new to learning about the StockHistory Function. Any thoughts on the matter are welcome. I tried all that I could from this site below: https://support.microsoft.com/en-us/office/how-to-correct-a-connect-error-584f7de9-b238-480c-8e8f-de0ba2c1aac9
Excel Drag and Fill Handle not working as I would like
I am copying references from one workbook to another for organization. Both Workbooks are organized in tables. Earlier today I was able to filter table 2, by category in Column I, and paste the new Reference code in the correspoding Column M cell. For example I would filter by Column I in Book 2, Table 2, and the copy the reference from book 1, table 1. I would paste the reference into Cell M2. Because I had the filter applied I wanted to apply the reference to the end of the table in column M. So I was able to double click the drag and fill handle, and it would populate the rest of column M below in the table with identical references. Now, when I use the exact same method, double-clicking the drag and fill handle changes th reference entirely to previous reference no longer needed. The only options I have accessed were "Special" trying to clear formulas in other columns while leaving the text. Enable Fill handle and cell drag and drop, and Automatic Flash fill are both enabled. what is causing my issue, and how do I fix it?
Cell Use from one sheet to Another
Hello. I have a multi-page workbook that requires using cells from one sheet on other sheets in the same workbook. I have one instance that in trying to work it out, has caused a second issue. When I try to add the cell from the one sheet to the next sheet using +=, then clicking on the sheet and cell to acquire it, when it posts is a 0. In trying to solve my issue and going to the sheet and cell in question, this is what I see. Highlighted cell. So, initially I was able to total that column. Now I can't because it no produceds a 0. It seems for some reason that cell does not show as =+'Wages'!G15, if I manually input that in the cell I need it in (on the other sheet) it still posts as 0. The source sheet for Wages is below this sheet. Can anyone help me get this worked out so I can use the required cell on the sheet i need to use it on?
Excel not publishing OLE
Excel no longer publishes any OLE clipboard formats in build 16.0.19725.20078. Copying a cell and using Paste Special in Word/OneNote shows no “Paste Link” and no “Microsoft Excel Worksheet Object.” Only text/HTML/bitmap formats appear. This blocks creation of linked or embedded Excel objects. Issue is fully reproducible: new workbook, enter value, copy, open Word → Paste Special. Expected: Paste Link + Excel object formats. Actual: missing. Verified after full repair, reinstall, Safe Mode, new profile, add‑ins disabled. Excel→Excel copy works; Excel→external OLE formats do not. This appears to be a regression in the OLE clipboard publishing pipeline for this build family.
Update changed open settings
I don't know if it was an Excel update or OneDrive update, but I no longer have my favorites or recent files that I saved on my computer showing up in the home screen. Now it just defaults to the One Drive location even though I have turned off save to One Drive and turned on save to computer and given it a default location. I am at a loss any help will be appreciated. I thought I published this earlier, but cannot find it so am trying again. Thank you for any help and take care.Still learning Excel and got an update that changed my open screen
It looks like Excel updated last time I closed it and now when I start it all my favorites are gone as well as recent files. I don't use One Drive and it just defaults to looking at One Drive. Even after I have opened different files on my computer they do not show up in the Recent files. How can I reset this so I can get back to my old screens and set up favorites again as well as see my recent files opened and not default to One Drive. I have changed the settings in the Save Options so it does not save to the cloud and the default location is not One Drive, but I can't seem to get the opening screen to show recent files or my favorites. Any help will be appreciated. Thank you in advance for this. Take care.
Macros open server file hyperlinks in 2nd instance
Macros open server file hyperlinks in 2nd instance, preventing macros from seeing and interacting with the newly opened file. Manual clicking of hyperlink opens the files in the same instance as expected. Users with fresh login have no trouble with the macros opening the files in the same instance. Esoteric macro and/or Microsoft 365 Active Directory problem. Macros using hyperlink in a cell to .follow them to open. Then the next line is a sheet selection of a sheet in the new workbook. Error thrown because the new workbook is not visible to the macro and does not see the sheet name. This works for everyone everywhere. Including on fresh logins. Recently User1 started having the 2nd instance problem. I thought it was isolated and fixed it by removing and recreating his profile. Worked fine for a week. Then it came back. Then User2 logged in on the same machine had the issue. Then the next day User3 on a separate machine had the issue. All 3 users have no issues if they just use a clean login on a different machine. If you manually open all the necessary files, THEN run the macro, it still errors because when it tries to open the already-open-file, it gives the standard Read only Notify me Cancel dialogue. It says [self user] is using it and the file is locked. So is it even a macro problem or is it a server problem? Our server admin says it's not his problem and he has no idea what's happening and it's probably our crappy macros. Yes, our macros are crappy, recorded decades ago. But they work as expected except in these rare but spreading cases, seemingly due to some background environment development.
XLOOKUP search w/multiple output
I've been working on a project and I am completely stumped. I cannot wrap my brain around how to get this to work. In the example below, I want to Enter a number in either of the top two field and have the last three fields populate. Now, I can get this to work for one, but not the other and for some reason when I switch from bottom search to the top search the old data doesn't clear and the search doesn't work. This is the formula I have so far //=XLOOKUP(H8,A2:A10606,B2:B10606) Anything I have done after has been a disaster
