Windows 10: excel reports

Discus and support excel reports in Windows 10 Customization to solve the problem; why when i open my excel reports it always ask me to sign into microsoft i cant copy the file into an another report... Discussion in 'Windows 10 Customization' started by TanaWagoner, May 26, 2020.

  1. excel reports


    why when i open my excel reports it always ask me to sign into microsoft i cant copy the file into an another report

    :)
     
    TanaWagoner, May 26, 2020
    #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:
    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 reports :)

    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, May 26, 2020
    #2
  3. Silverel Win User
    Guide: How to enable, use, and configure SLI on Linux.

    I guess the next logical step would be to report on the performance you can get with SLI in Linux. That'd be my suggestion anyway.
     
    Silverel, May 26, 2020
    #3
  4. Try3 Win User

    excel reports

    Excel 2010 Document Inspector reports hidden sheets, not shown in VBA

    Just a wild shot in the dark ...

    Didn't macros get recorded in worksheets before Excel switched to VBA?
    - I can't think how far back this was. Possibly Excel 4 in the early 1990s.
    - Of course, this would make no sense at all if your workbook had been created since, say, Excel 2007.

    If your workbook is older than that I'd suggest
    1 Create a new blank one then, with both open at once, use the sheet tab Move or copy ... to copy each sheet to the new blank workbook.
    2 In the VBEditor of the new workbook, create two new modules [Functions, Procedures] and then just copy the code text across from one to the other.
    3 In the VBEditor window of the old one, in the Microsoft Excel objects list select each sheet in turn {including ThisWorkbook} then right-click and select View code. If there is anything in any of them, copy it to the same place in the new workbook.

    excel reports [​IMG]



    Denis
     
Thema:

excel reports

Loading...
  1. excel reports - Similar Threads - excel reports

  2. Mediocre sound quality despite excellent speakers

    in Windows 10 Gaming
    Mediocre sound quality despite excellent speakers: I have just gotten a new Win laptop - MSI Stealth 16, supposedly a great laptop - and have been struggling to get good, acceptable sound quality. I come from an old mac, where the sound was terrific. What's problematic:I've tried various equalisers in Win 11 including Boom,...
  3. Mediocre sound quality despite excellent speakers

    in Windows 10 Software and Apps
    Mediocre sound quality despite excellent speakers: I have just gotten a new Win laptop - MSI Stealth 16, supposedly a great laptop - and have been struggling to get good, acceptable sound quality. I come from an old mac, where the sound was terrific. What's problematic:I've tried various equalisers in Win 11 including Boom,...
  4. Even though I have changed my excel default font, when I download reports to excel from a...

    in Windows 10 Software and Apps
    Even though I have changed my excel default font, when I download reports to excel from a...: I have changed the default font of my excel workbooks. However, when I download a report from a different system to excel Power BI, SAP BW etc it always download in "Arial".Is there a way for me to change that to a different font as well? So that any excel document I download...
  5. Even though I have changed my excel default font, when I download reports to excel from a...

    in Windows 10 Customization
    Even though I have changed my excel default font, when I download reports to excel from a...: I have changed the default font of my excel workbooks. However, when I download a report from a different system to excel Power BI, SAP BW etc it always download in "Arial".Is there a way for me to change that to a different font as well? So that any excel document I download...
  6. Even though I have changed my excel default font, when I download reports to excel from a...

    in Windows 10 Gaming
    Even though I have changed my excel default font, when I download reports to excel from a...: I have changed the default font of my excel workbooks. However, when I download a report from a different system to excel Power BI, SAP BW etc it always download in "Arial".Is there a way for me to change that to a different font as well? So that any excel document I download...
  7. Reports from quickbooks to excel

    in Windows 10 BSOD Crashes and Debugging
    Reports from quickbooks to excel: Reports from Quickbooks to excel, computer will not do an excel worksheet but will download in a csv file? not enough memory? https://answers.microsoft.com/en-us/windows/forum/all/reports-from-quickbooks-to-excel/03ec4441-4bad-44ca-aae4-fc48b12c084d
  8. IE issue - unable to export the report from IE 11 in excel

    in Windows 10 Customization
    IE issue - unable to export the report from IE 11 in excel: Hi all, I have an issue exporting reports from IE 11 to excel. Configuration: OS Version: Windows 10 Browser version: IE 11 Web Application: Oracle Enterprise Performance Management Workspace MS Excel version: Office 365 v 16.0 Steps to reproduce the Issue: 1. Open...
  9. Excel 2010 Document Inspector reports hidden sheets, not shown in VBA

    in Microsoft Office and 365
    Excel 2010 Document Inspector reports hidden sheets, not shown in VBA: I have a worksheet with 14 tabs along the bottom. I've had the worksheet for many years - creation date is 16 November 1997 -and it's evolved over time to be more and more useful. Obviously been through many versions of Excel. It has several user functions and VBA procedures....
  10. Is it possible to convert a report from Notepad to excel?

    in Windows 10 Software and Apps
    Is it possible to convert a report from Notepad to excel?: One of our online suppliers sends reports in Notepad; is there a way to convert to Excel? https://answers.microsoft.com/en-us/windows/forum/apps_windows_10-winapps-appscat_finance/is-it-possible-to-convert-a-report-from-notepad-to/c13a4033-5074-468f-9441-aed96db26c64