Windows 10: Validating links in Excel

Discus and support Validating links in Excel in Microsoft Office and 365 to solve the problem; Not sure if anyone here can assist but here goes :) I haven't found a working solution online for this yet so i'm picking brains. What i've done is... Discussion in 'Microsoft Office and 365' started by kormath, Oct 21, 2019.

  1. kormath Win User

    Validating links in Excel


    Not sure if anyone here can assist but here goes Validating links in Excel :) I haven't found a working solution online for this yet so i'm picking brains.

    What i've done is created an excel file with all of the internal apps that my company uses. We're in the process of changing them over from http to https. I've created the URL rewrite for each app.

    Now i just need to test the URL. Since they're all listed in Excel, i was hoping for a way to do this easier than clicking the 200+ links and making them open in the default web browser. I found a way to create a function in excel to do this for http links but it doesn't work for https.

    Ideas? or am i stuck clicking each link to test *Sad

    :)
     
    kormath, Oct 21, 2019
    #1

  2. does WP7 excel support or is there future plans to support data validation lists

    HI all

    just a quick question i was wondering, as the title suggests, if WP7 excel will support data validation lists as i know that the excel in WP6.5 did not. If the new excel does not support data validation lists is it possible to request that this feature be
    included in future updates as i find them quite handy.

    look forward to a reply

    all the best
     
    killerfodder, Oct 21, 2019
    #2
  3. does WP7 excel support or is there future plans to support data validation lists

    Hello Killerfodder,

    Unfortunately, mobile excel does not support data validation lists at this time. Also there is no official information on upcoming feature implementations.

    Regards,

    Sergio P.
     
    Sergio P ., Oct 21, 2019
    #3
  4. ddelo Win User

    Validating links in Excel

    Export All Administrative Events to Excel


    To analyze events, from the Windows Event Viewer, there is a simple way to export all Administrative Events to Excel, with PowerShell.

    Exporting all Administrative Events to Excel is a simple two Step process, as described here:

    Step 1 - Create the Administrative Events View .xml file
    1. Open Eventviewer (%windir%\system32\eventvwr.msc)
    2. Navigate to: Event Viewer (Local) > Custom Views > Administrative Events
    3. In the “Actions” pane select “Filter Current Custom View”.
    4. Select the the XML tab.
    5. Press Ctrl+A to select all the XML code of the Custom View.
    6. Open a notepad, paste the selected code and save the file to your Desktop as AdmEvtView.xml


    Step 2 - Create the csv file with the events
    1. Download the ExportEvtCSV.zip file, which contains the script ExportEvtCSV.ps1 and unzip it, on your Desktop.
      It's not a fancy script, just basic PowerShell commands to create a csv file on the Desktop.
    2. In Windows Search, type “ISE” (without the quotes) to open “Windows PowerShell ISE” and Run as administrator
    3. To allow running the script, change the ExecutionPolicy, for this session. To do that, in the Console pane type:
      Code:
      Code:
      Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass -force
    4. In the Windows PowerShell ISE, open and run the script: ExportEvtCSV.ps1
      The script will create a csv file with a name YYYYMMDD.HHMM.csv on the Desktop
    5. When done, open the newly created .csv file, format the columns as needed and optionally save it as .xlsx, if you wish.
    That’s it! You now have all the Administrative Events in Excel for filtering and further analysis. Validating links in Excel :)

    Now to the more technical hard stuff... *Confused

    There is a reason for running the script from within PowerShell ISE!

    It would be great if everything was also working perfectly, when running the script from an elevated PowerShell too.

    We can run it from an elevated PowerShell, which means that you just follow the Step 1, as above but for the Step 2 instead of the ISE you run the script from an elevated PowerShell.

    The problem is that it will work only for anybody who has en-US format for the dates. Everyone else, who has another format (i.e. en-GB, fr-FR, el-GR etc.), the dates are not translated properly by Excel (although the script uses the –UseCulture switch) and remain as text in the en-US format.

    I'm not sure if this a bug of the "export-csv" cmdlet, but although it runs the way it supposed to from within the ISE, from PowerShell there is a problem with the dates format.
    As I haven’t found a way to overcome this obstacle, any suggestion from the PowerShell gurus of the forum (like my good friend Shawn @Brink, for instance), is welcome.
     
    ddelo, Oct 21, 2019
    #4
Thema:

Validating links in Excel

Loading...
  1. Validating links in Excel - Similar Threads - Validating links Excel

  2. Directory not valid

    in Windows 10 Installation and Upgrade
    Directory not valid: I can search and see the document that I need to bring up but when I click on it it says "The directory name isn't valid" https://answers.microsoft.com/en-us/windows/forum/all/directory-not-valid/06a38702-4a31-471b-a5ea-cf9794a94576
  3. impossible to validate with a legitimate validation number

    in Windows 10 Updates and Activation
    impossible to validate with a legitimate validation number: I have a similar problem as many users here. After a black screen I reinstalled windows 10. Originally my laptop came with windows 8.1 and a free upgrade to 10. After reinstall, a window asking for validation disappeared. I tried doing it at settings but the screen was...
  4. excel

    in Microsoft Windows 10 Store
    excel: I just downloaded and installed Excel, however, I was sent an email with xls spreadsheet which won't open, why? Is my program not working or perhaps the wrong version? All I get is gobble-d-goop on a notepad format....
  5. Excel

    in Windows 10 Customization
    Excel: When I boot up my computer it automatically loads 3 or 4 or 5 or 6 or 7 instances of Excel. This is slowing down my boot process and closing them all is a nuisance. Is there some way to stop this from happening? Thanks....
  6. Excelling at failing Excel

    in Windows 10 Software and Apps
    Excelling at failing Excel: First off, I’m an Excel idiot. I use Word exclusively, and only use Excel when it’s someone else’s document and I don’t have a choice. Now would be one of those times. I do want to learn, but right now, I’m an idiot. At work, there’s an Excel spreadsheet that freezes when...
  7. excel

    in Windows 10 Software and Apps
    excel: In hospital bill i want to find ward charges but i don't know the formula https://answers.microsoft.com/en-us/windows/forum/all/excel/2504def0-9b7c-4ec7-a221-e59d629725d3
  8. Excel

    in Windows 10 BSOD Crashes and Debugging
    Excel: When I save an open file from my QuickBooks software, I get message there may not be enough memory to do this and wants to save as a csv file. I have almost a Terabyte available. Not sure what to do. Mike...
  9. Convert EXCEL sheets to MySql / MariaDB with links to music

    in Windows 10 Software and Apps
    Convert EXCEL sheets to MySql / MariaDB with links to music: Hi folks I'm trying to create a decent Music Database Basically rather than messing around with zillions of files / tracks / playlists etc I want to use one of the Free database systems (MySQL / MariaDB - both similar and work on Windows). I have a load of spreadsheets --...
  10. Access Denied appears when posting valid Links

    in Windows 10 Support
    Access Denied appears when posting valid Links: Looking for some general forum help. Occasionally I will post a valid link, like to the Microsoft Media Creator and when I submit the link is replaced by the words Access Denied. Today I posted one to an AVG forum. Does someone know why this occurs? Is the forum scanning...