Windows 10: Excel entry problem

Discus and support Excel entry problem in Microsoft Office and 365 to solve the problem; Good morning. I am running Win 10 ver 1803 and recently updated it. I have a problem never encountered before. My Excel worksheet does not allow me to... Discussion in 'Microsoft Office and 365' started by metromiami74, Oct 12, 2018.

  1. Excel entry problem


    Good morning. I am running Win 10 ver 1803 and recently updated it. I have a problem never encountered before. My Excel worksheet does not allow me to enter a dollar figure. What comes up when I try is what appears to be a cursor flashing line. How do I fix this? Thanks.

    :)
     
    metromiami74, Oct 12, 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 entry problem :)

    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 12, 2018
    #2
  3. Excel not recognized as an app in Windows 10.

    I have the same problem. If I go to "Set defaults by App", there is no Excel 2016 entry, although Excel is installed and does work fine. How can I make Excel to appear in this list?
     
    RenéHübscher, Oct 12, 2018
    #3
  4. dalchina Win User

    Excel entry problem

    Windows 10 1709 System Restore problems...


    That seems to be an attempt at Option 2 in the tutorial, which requires you to
    a. Boot to a command prompt (Did you?)
    b. You then seem to be mixing steps 3,4 and 5, thus your command is incorrect.

    I suggest Option 1 is easier.

    If you still have problems, please repost listing each specific step and saying which option from the tutorial you are using. Thanks.
     
    dalchina, Oct 12, 2018
    #4
Thema:

Excel entry problem

Loading...
  1. Excel entry problem - Similar Threads - Excel entry problem

  2. NEED HELP!: Excel tricky problem

    in Microsoft Office and 365
    NEED HELP!: Excel tricky problem: Hello everyone, I am using EXCEL, and having this problem, which I think, tricky but easy to understand: Column A and Column C both contain INPUTS (all are numbers). Column B should contain OUTPUTS. (Which is the problem). The problem in words: Look at Column A, Find the...
  3. Excel jumplist entries won't stay pinned

    in Microsoft Office and 365
    Excel jumplist entries won't stay pinned: I have moved my OneDrive folder from its default location to D: In my Excel recent files list I sometimes see two entries for a file One has the path D:\OneDrive etc and the filename includes the file extension The other has the path https://d.docs.live.net etc and does not...
  4. Excel jumplist entries won't stay pinned

    in Windows 10 Software and Apps
    Excel jumplist entries won't stay pinned: I have moved my OneDrive folder from its default location to D: In my Excel recent files list I sometimes see two entries for a file One has the path D:\OneDrive etc and the filename includes the file extension The other has the path https://d.docs.live.net etc and does not...
  5. Excel problem after Browser update

    in Windows 10 Installation and Upgrade
    Excel problem after Browser update: Hi - after I updated my browser yesterday, my Excel files look very strange. Everything is inverted, even the row numbers. I'm assuming I have to update Excel now also. How do I do that? I'm running a MacBook Air and I have the subscribe plan. Thanks Murray Fein...
  6. Problems with excel over network share

    in Windows 10 Ask Insider
    Problems with excel over network share: Hi folks. In my office, we are having problems with office files in general, when working on a FileShare server. When opening a file it takes a lot to open, and sometimes it crashes. Also the explorer when navigating the FileShare, it crashes too. It started happening like...
  7. Touch keyboard won't stay on number entry in Excel

    in Windows 10 Customization
    Touch keyboard won't stay on number entry in Excel: I am having an issue specificly with the Mircosoft Surface's touch screen keyboard (the tablet touch keyboard, not the accessibility on-screen keyboard). The keyboard switches back to the alphabet keyboard screen (which has no numbers) after using the numeric touch keyboard...
  8. Text entry problem

    in Windows 10 Installation and Upgrade
    Text entry problem: I have a text entry problem in that I cannot input text from my keyboard or the touchscreen keyboard. They are not unresponsive. If I just push random keys, things happen. There was a similar thread elsewhere, but the solutions involve running things using run or cmd prompts,...
  9. DLL file in System32 and Excel problem

    in Windows 10 BSOD Crashes and Debugging
    DLL file in System32 and Excel problem: Good afternoon - I don't know if this is a Windows or Office question, so I'm asking it in both sections. I'm experiencing a difficult problem with Excel, in Office Pro 2019, on a desktop computer running Windows 10 Pro, version 1809. This started last Tuesday morning...
  10. Excel entry problem

    in Windows 10 Support
    Excel entry problem: Good morning. I am running Win 10 ver 1803 and recently updated it. I have a problem never encountered before. My Excel worksheet does not allow me to enter a dollar figure. What comes up when I try is what appears to be a cursor flashing line. How do I fix this? Thanks. 119719