Windows 10: Excel

Discus and support Excel in Windows 10 BSOD Crashes and Debugging to solve the problem; 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... Discussion in 'Windows 10 BSOD Crashes and Debugging' started by MikeCoInc, Nov 8, 2018.

  1. MikeCoInc Win User

    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

    :)
     
    MikeCoInc, Nov 8, 2018
    #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, Nov 8, 2018
    #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, Nov 8, 2018
    #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, Nov 8, 2018
    #4
Thema:

Excel

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

  2. Deleted apps for word 2010, excel 2010, powerpoint 2010

    in Windows 10 Software and Apps
    Deleted apps for word 2010, excel 2010, powerpoint 2010: My PC had to be reset today. After I noticed my Microsoft Word 2010, Excel 2010 & Powerpoint 2010 were gone. I do have my original receipt but not the original packaging. How can I reinstall these apps....
  3. Excel crashes when clicking on a external Hyperlink

    in Microsoft Office and 365
    Excel crashes when clicking on a external Hyperlink: Hello - I have one computer on build 17763.475 version 1809, the rest are version 17763.437. On this particular computer whenever you click on an external hyperlink, excel closes. I have read several forums where it says to remove the "god-mode" folder, but I don't see...
  4. Excel cannot open files

    in Windows 10 Network and Sharing
    Excel cannot open files: I found in the last two to three days that XLSX files are not opening and i am getting the below mentioned message. Can you please help out Excel cannot open the file 'Salary working file Feb'19.xlsx' because the file format or file extension is not valid. Verify that the...
  5. MSWord EXCell and Outlook

    in Windows 10 Installation and Upgrade
    MSWord EXCell and Outlook: I Had the MSOffice on my PC but after MS Windows upgraded my system, I have to pay PER YEAR for them now. Where did they go? https://answers.microsoft.com/en-us/windows/forum/all/msword-excell-and-outlook/a71bbbd7-f38c-481e-8e82-22847f8990c2
  6. Microsoft Office App Virtualization Client Error 1068 Excel won't start on Win 10Pro

    in Windows 10 BSOD Crashes and Debugging
    Microsoft Office App Virtualization Client Error 1068 Excel won't start on Win 10Pro: First tried to Start the App Vis Client, and got Error: 1114: A dynamic link library (DLL) initialization routine failed. Then got the 1068 error. Downloaded and installed the thing you recommended, OpenOffice, but don't know how to use it for this problem....
  7. Excel 2103 adding digits to column

    in Microsoft Office and 365
    Excel 2103 adding digits to column: Hi guys can I ask for a little advice please I have an excel 2013 spreadsheet formatted as a table I have attached a screenshot to explain better As you can see I have a rows of dates in the header row IE 12th 13th 14th and so on to the left of the yellow column but when I...
  8. Windows 10 automatic update 5/12 wiped out word and excell office instalations

    in Windows 10 Installation and Upgrade
    Windows 10 automatic update 5/12 wiped out word and excell office instalations: Windows 10 automatic update on 5/12/19 wiped out excel and word installations. Icons missing and it looks like it is running through the install procedure again. Lost chrome browser favorites...
  9. Unable to start Excel and Word

    in Windows 10 Network and Sharing
    Unable to start Excel and Word: I have windows 10 and I have on my machine Office 2016. I have the icons for word, excel and one note on the task bar. One note will open with the usual double click on its icon however neither word nor excel will open without highlighting the icon and selecting open as...
  10. Excel 2016 Force Legacy Workbook Sharing or Ribbon button with Policy?

    in Microsoft Office and 365
    Excel 2016 Force Legacy Workbook Sharing or Ribbon button with Policy?: Hello all, I am trying to migrate a bunch of users to Office 2016. Upon doing this i noticed that the Share Workbook functionality in Excel 2016 has been replaced with co-authoring. We use the share workbook functionality for editing files with multiple users on a local...

Users found this page by searching for:

  1. cant save excel file to location because cached credentials have expired sign in fails