Excel (365 & 2016) with network information...and much more Information to Filter.
With Excel (365 & 2016) Network information, information about Local Network Connectivity, Test Connection to a Specific Web URL, WiFi SSID information ...and much more information to filter with a button. I was trying to create a tool that would allow me to filter the necessary information from all the PCs I need to work on using a USB stick. I came across an old file that I edited and added additional information to the code. I'd like to share this file (Help for self-help). If anyone finds it useful, or would like additional tips or information, please feel free to send me feedback. If it doesn't help you...just ignore it. I welcome any constructive comments. * After loading the file, be sure to activate all macros. Happy Excel-ing! 🙂
OneDrive folders when switching to a new computer
Hi All Let me first explain what I have setup I have created my OneDrive on my computer to sync only selected folders to my SD card. (Many reasons and I have found this very useful) I customized the OneDrive location using this article https://support.microsoft.com/en-us/office/install-onedrive-on-an-external-drive-6307e24b-d7a4-493f-bf43-47345b2c11fe I now have a new computer and will be just moving this SD card over and all my data should be there and ready to go. I have only selected some of the OneDrive folders to sync and of them some of it is made locally available so I can work on them even if I am off line (like traveling on a plane with no internet) or am in the woods or very remote locations where I get no connectivity. Now to the question I plan to setup my new computer with the SD card and hopefully can follow the article (https://support.microsoft.com/en-us/office/install-onedrive-on-an-external-drive-6307e24b-d7a4-493f-bf43-47345b2c11fe) and once more link up the SD card (with all the information it has locally) Where does Windows 10/OneDrive store information about which are the folder I have selected and what to do with them? I cannot find this information and maybe I do not need it - unsure about this. If I do as stated in article https://support.microsoft.com/en-us/office/install-onedrive-on-an-external-drive-6307e24b-d7a4-493f-bf43-47345b2c11fe with the old SD card in my new computer will I be up and running or is there something I should follow to make this work well. Remember I cannot have the SD card in two locations to know the information. Any guidance or pointers from any one who has done this would be very helpful. I wish MS helps people who want to customize or adapt things by giving more clear instruction on how they design or document so people can customize. I struggle with this and how MS does their software. While on OneDrive - anyone written batch files on the computer to create onedrive folders, then share it with users along with setting expiration dates? These can be done on the browser, but one folder at a time with clickoholic interface and it gets repetitive very quickly if you have to do this for 40 students every semester - Of course MS has not way of doing this at all (at least to my knowledge and my reading)
Having trouble with IF formula
Hello, I'm not sure what's going on with my formula, but it is supposed to double the "Grip" when a checkbox is checked. All the numbers being pulled from tables are correct and when not checked the "Grip" adds up correctly. When doubled, it is also adding the "Wall Thk." number an extra time. Correct single Grip = 1.625" Correct double Grip = 3.25" I get 3.5" for double grip. Formula used below, as well as pictures. If my formula is wrong, then I can't see it, but it has to be adding T8 somehow. =IF(X8,((INDEX(DATA_THK,MATCH(1,(Flg_Thk[Spec.]=N8)*(Flg_Thk[Series]=O8)*(Flg_Thk[Class]=P8)*(Size=Q8),0),MATCH(R8,FLG_TYPE,0))+T8*(R8="Lap Joint (LJ)")+V8*(U8="RF"))*2),(INDEX(DATA_THK,MATCH(1,(Flg_Thk[Spec.]=N8)*(Flg_Thk[Series]=O8)*(Flg_Thk[Class]=P8)*(Size=Q8),0),MATCH(R8,FLG_TYPE, 0))))+T8*(R8="Lap Joint (LJ)")+V8*(U8="RF")All the sensitivity labels are not showing in the new outlook
I recently noticed that some sensitivity labels are missing in Outlook. I used to see all four labels—Public, Internal, Confidential, and Restricted—but now I only see Public and Internal. The full list still appears in Word and PowerPoint. I just switched to the new Outlook experience and the issue persists there.
Why is Excel macros sometimes missing ?
I have an excel file with a lot of rectangular shapes showing a tree structure for a family. When the user clicks on one of the rectangulat shapes the 'story' of that person opens up in a Word dokument. BUT ... Most often the macro 'assigned' to the OnAction WONT run - instead this message comes up: The macros is NOT shown when I "show macros" but it IS present in the VBA section when I press alt+F11 ! When it's working it's most often reight after a reboot og the machine - then it maybe works in 10-30 minuts and then the problem is back again ! I HAVE chesked the security setting allowing macros to be activated ! I have tha SAME file running under Window 10 for years WITHOUT any problems !!!! I can see out there that people FOR YEARS have had similar problems with missing macros - but unfortunately I found no solution ! What the _BEEP_ is wrong here ?
Macros being blocked in Excel even though file is located in trusted site
I am experiencing an issue that I have seen several discussions about, however there does not appear to be an answer so I wanted to see if anyone has found an answer for this. I have a user that is getting the following message in excel when opening a file on a network share: Microsoft has blocked macros from running because the source of this file is untrusted. I have confirmed that the file location is in the Trusted Center and in addition, this issue just started happening recently with no changes that I am aware of. I have also placed the server IP and Server name of the server in the Trusted sites under Internet Options, but this did not change the issue. Here is some info about the system: Windows 10 Pro 10.0.19045 Build 19045 Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20124) 64-bitEnd of support for Access 2016 and Access 2019 nears
Your product will still work, but when Microsoft says a product has reached "end of support", it means the product will no longer receive: Security updates Non-security updates Bug fixes New features Assisted support (free or paid) What this means for Access users: No more updates: Customers will not receive any new builds, patches, or improvements—even if vulnerabilities are discovered. No support: Microsoft will no longer provide technical support or troubleshooting assistance. Increased risk: Continued use of unsupported software can expose systems to security threats and compliance issues. Migration encouraged: Customers are advised to upgrade to a supported version or product to maintain security and functionality. We strongly encourage all Access users with perpetual licenses to upgrade to a Microsoft 365 Apps subscription. Subscription users get more out of the same Office desktop apps with artificial intelligence (AI) backed design ideas and analytic insights, rich contents and templates, cloud powered connected experiences and more. They also enjoy additional benefits beyond capabilities in Office apps, such as 1TB storage, Office on multiple devices and mobile, Microsoft Family Safey app, etc. I've noticed many perpetual users are "subscription adverse." I hear "I've used the desktop version forever and prefer not to switch to the cloud." Migrating to subscription does not mean that you'll get a different version of Access. You'll still get the desktop version you know and love, plus all the premium Office features a subscription provides. My favorites are Editor in Word, Money in Excel, and all the extra OneDrive storage. Check with Microsoft Sales Support to see if you're eligible for upgrade incentives depending on your region or organization type. (Yes, we know the Access icon does not appear with the other Office apps. You'll find it directly below the icons in the alphabetized apps list.) Sources: End of support for Office 2016 and 2019 Overview - Product End of Support and Retirements - Microsoft Lifecycle Access 2016 - Microsoft Lifecycle Access 2019 - Microsoft LifecycleAccess announces removal of Salesforce ODBC driver in October 2025
MS Access 2019 (and newer) ships a licensed Salesforce ODBC driver from InsightSoftware that will lose sustaining support after June 30th, 2026. But because we can no longer provide updates for the driver, the Access team has decided to accelerate the removal of this driver and remove it from the product in October 2025. Applies to: Access 2019 volume licensed and Enterprise plans Access 2021, Access 2024, and Microsoft 365 subscriptions Access 2021 and Access 2024 as part of the Office 2021 and Office 2024 perpetual licenses (standalone versions) The Salesforce ODBC driver bundled with Office includes shared libraries such as: libcurl.dll libcrypto-3.dll libssl-3.dll These libraries are located under the following path: Program Files\Microsoft Office\ODBC Drivers\Salesforce. They may also be present in different locations. Drivers installed by Office and used to access your Salesforce data will be removed on permanently on October 28, if you are using Access as part of a Microsoft 365 Apps monthly version and on November 11 if you are on the semi-annual release. For customers using perpetual Access 2019, 2021, or 2024, the drivers will be removed on November 11. You do not need to manually remove the drivers. Access currently doesn't have a way to talk directly to the Salesforce APIs so customers must continue to use the standardized ODBC driver framework that we currently support. Customers can independently purchase the Simba.DLL driver if needed from InsightSoftware. There are also other vendors that offer a Salesforce driver. Simba driver from InsightsSoftware https://insightsoftware.com/simba/ ODBC driver from devart https://www.devart.com/odbc/salesforce/ Salesforce integration from boomi https://boomi.com/solutions/application/salesforce/ Salesforce driver from cdata https://www.cdata.com/drivers/salesforce Once you purchase and install the driver, Access can connect to your Salesforce external data source. On the External Data ribbon, choose New Data Source > From Other Sources > ODBC Database We will provide more updates when available.
