Windows 10: Excel

Discus and support Excel in Windows 10 Network and Sharing to solve the problem; i have lost my "save as" facility that i had prior to my discussion last week... Discussion in 'Windows 10 Network and Sharing' started by GerardMcAuliffe1, Jun 13, 2019.

  1. Excel


    i have lost my "save as" facility that i had prior to my discussion last week

    :)
     
    GerardMcAuliffe1, Jun 13, 2019
    #1
  2. ddelo Win User

    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. 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, Jun 13, 2019
    #2
  3. dalchina Win User
    CSV files used to open in Excel....not now!


    Hi, you say Excel is installed. Does it run normally?

    You can't find Excel in (an unspecified) list of applications. I don't know which list that is for sure.

    For example, in the list related to:
    - rt click a file. Open With
    - this list:

    Excel [​IMG]

    - this list:

    Excel [​IMG]


    - some other list...

    If Excel does not appear in the above, I suggest you repair your office installation.

    Maybe the above gives you some ideas. Otherwise please post a screenshot of where you think you should see it but don't. Thanks.
     
    dalchina, Jun 13, 2019
    #3
  4. Excel

    Excel printing

    Hi Joseph,

    Thank you for posting your query in Microsoft Community.

    Does this issue only occur with Excel file or nay other files?

    Try to copy the excel file to the other drive and check if it is working?

    Run Print Troubleshooter

    The built-in Printer Troubleshooter can automatically detect and fix most of the incorrect settings and errors that could cause issues while printing. I would suggest you to run this troubleshooter to check if there is any issue with the sound. Refer
    top these steps:

    • Click on Troubleshooting and select the
      view all option on the left pane.
    • Click on Printer troubleshooter and follow the online instructions.

    If this doesn’t help. Try to repair the Microsoft Office Application.

    Do let us know if you have any other queries pertaining to Windows in the future. We will be happy to help.

    Thank you.
     
    SujataMoktan, Jun 13, 2019
    #4
Thema:

Excel

Loading...
  1. Excel - Similar Threads - Excel

  2. How do I submit photos to MSN for web site display to viewers. EXCELLENT QUALITY. RESPOND...

    in Windows 10 Customization
    How do I submit photos to MSN for web site display to viewers. EXCELLENT QUALITY. RESPOND...: I HAVE AN AMAZING SET OF PHOTOS FROM MY PRIVATE COLLECTION, WHICH ARE ARTISTICALL STUNNING. HOW DO I OFFER, NO FEE, THESE PHOTOS TO APPEAR WHEN MY SURFACE 3 TABLET OPENS????? Dr. LARRY MCKENNA...
  3. Excel file reversion-only original file viewable

    in Windows 10 Network and Sharing
    Excel file reversion-only original file viewable: When trying to open an excel file saved last week, it opened as its version from 2017. The file is in the previous documents list, but when I open it, says file was moved or deleted. I’ve gone into the recovery files, but since the document from 2017 has the same name, its...
  4. Excel has been removed from my PC

    in Windows 10 Network and Sharing
    Excel has been removed from my PC: Hi, Can anyone help? I have all other Office programs but Excel has gone?? https://answers.microsoft.com/en-us/windows/forum/all/excel-has-been-removed-from-my-pc/d4e56f69-f4c8-4734-a53a-841e852a779f"
  5. Excel and Access automatically launch on Windows 10 start

    in Microsoft Office and 365
    Excel and Access automatically launch on Windows 10 start: From about 3 days ago whenever I start Windows 10 several instances of Excel and Access are automatically launched. I have checked the Startup Apps and there are no Office apps in the list. How do I find what is causing these apps to launch? 135063
  6. Excel and Access automatically launch on Windows 10 start

    in Windows 10 Support
    Excel and Access automatically launch on Windows 10 start: From about 3 days ago whenever I start Windows 10 several instances of Excel and Access are automatically launched. I have checked the Startup Apps and there are no Office apps in the list. How do I find what is causing these apps to launch? 135063
  7. Microsoft Adds Dynamic Arrays and New Functions in Office Excel

    in Windows 10 News
    Microsoft Adds Dynamic Arrays and New Functions in Office Excel: Hi I’m Joe McDaid, a Program Manager working on new calculation experiences in Microsoft Excel. I wanted to share some details on an exciting enhancement to Excel’s calculation engine that will supercharge your formulas. Formulas just got better Until now, you wrote a...
  8. Unable to open the hyperlinks on Outlook and Excel, Error : Thise Operation has canceled...

    in User Accounts and Family Safety
    Unable to open the hyperlinks on Outlook and Excel, Error : Thise Operation has canceled...: My problem don't solving. 20 day is not possible to using my Office 2007 Entropies in Excel Hyper Link, Outlook and Excel chit in which I 'have different email address and internet address. (don't possible to open web site annexed in Outlook, in paste double click open no...
  9. Excel launching on start up

    in Microsoft Office and 365
    Excel launching on start up: Anyone find office apps launching on start up recently? It’s doing it on both our machines. We have 365 and use excel most. We always ensure the program is shut when doing shutdown. It’s a small issue but slightly irritating to see it launch when logging in 134523
  10. Excellent Support

    in Windows 10 Installation and Upgrade
    Excellent Support: How do I recognize a Microsoft suppot person for doing an exceptional job? https://answers.microsoft.com/en-us/windows/forum/all/excellent-support/89b06a8a-ca55-43a2-8a6e-98a7e880f138