Excel

Forum discussion tagged with Excel.
  1. noyaus

    Question Excel cannot be open the file 'filename.xlsx' because the file format or file extension is not valid

    Hi Guys, I have an issue with my Excel which is part of my Microsoft 365 Subscription. So what happens is whenever I try to open a document called 'A' on my USB I get the error: "Excel cannot be open the file 'filename.xlsx' because the file format or file extension is not valid." This issue...
  2. J

    Question How to have "Excel for Mac 2016" Auto-convert entry of yymmdd to yyyy-mm-dd

    Hi, 
 I want to type, say, 20201008 or 201008 into a cell and as soon as I press the enter or tab key have "Excel for mac 2016" immediately convert either entry to 2020-10-08. 
 I don't want to have another column set up that uses a formula to convert 20201008 or 201008 to 2020-10-08. 
 I...
  3. O

    Question How do i create an inventory management system with google sheets?

    Hello, I already manage my inventory with google sheets but i used to do it manually. Is there an option to pair a barcode scanner that will work with the sheet i already have?
  4. M

    Question Why is the taskbar not going back to hidden while excel is open?

    The problem only happens while excel is open. Unsure of how to fix, or why it's even happening. I will post the fix if I find it in the meantime.
  5. A

    Question batch file to clear contents in an excel file

    Hi, i need help in creating a batch file or a command prompt script to clear excel file contents without opening them clear file contents of file 1.xls file 3.xls file 4.xls please help
  6. J

    Question Excel files disappear to a user but not on the Server

    Good Morning Everyone, Need some help with this. We have an issue going on where if User A opens an excel document off the server, edits and saves, that it disappears. No other user can see it. However if we log into the server, it is shown there but it is locked so that the admin can not...
  7. T

    [SOLVED] Excel freezing when highlighting cells

    Hey Everyone, I am banging my head against the wall with an issue with a user here. She lives in Excel and she can do whatever she wants with formulas, macros, and everything else with zero issue. The problem is whenever she tries to highlight columns/rows, Excel freezes and stops responding...
  8. Joseph_Tech

    Question How to get Excel on my pc??

    I need to get excel on my windows 10 pc. I could use some help.
  9. osama_moussawi

    Discussion Laptop for Large Excell files

    Hi What is the best Laptop Specs (CPU) for processing large excel spread sheets files!
  10. T

    Question Microsoft Office 365 office365 Excel: setting up notification when an entry is made

    Hi All hoping someone can help and that this is the right place for my question, I am trying to setup a document via onedrive and sharing it with multiple people for multi user collaboration. The thing is i would like there to be some type of notification so when a user fills out the excel...
  11. nfogel0

    Question cant horizontally scroll in excel?

    I bought a USB trackpad/touchpad, and it does all the windows 10 gestures. When Im on a website for example, it scrolls vertically and horizontally no problem. but when im in excel, it only scrolls vertically and wont horizontally. How can I get it to scroll horizontally in excel via the...
  12. C

    Build Advice Trying to determine bottleneck - Excel 365 slowness

    I'm using a PC for business applications (lots of Excel applications, with large models and many colors). Works fine in Excel 2007, but find things slower in Excel 365. I find that the excel lags in certain situations (example: moving a window around by bar at top. example 2: Add a row in...
  13. P

    Just cause 4

    In JC4, after destroying all cores, it's written revisit some place (I don't remember the names) to make you own tornado sandstorm and blizzard, can it be done, if so how.
  14. H

    [SOLVED] Who do Freesync, Gsync or even Vsync exist? Wouldn't limiting your framerate to your monitor's refresh rate be much easier?

    Hello, I want to ask you something that has been annoying me for a while now. According to my understanding, the framerate being higher than your monitor's refresh rate would cause screen tearing. So Vsync is made to make your framerate be in sync with your monitor's refresh rate, but it caused...
  15. H

    [SOLVED] Broken Motherboard Part, Not detecting GPU!

    I was replacing the thermal paste on my laptop motherboard, Asus Rog GL502VT. Then accidentally found a broken component, maybe a resistor or something. When I booted back like that everything was normal but the graphics card was not detected. Is it due to this missing component it's not being...
  16. M

    Dual Link DVID to HDMI

    help, do i need active adapter or passive adapter for my Powercolor RX570 4gb.
  17. L

    Recommended RAM For My Build

    Hello everyone, I am beginning to finalise my build and I am wondering about RAM. My current choice is a Corsair Vengeance LPX 16GB (2x8) DDR4-4266. Since I know next to nothing about RAM could someone advise me as to if this is a good choice? Are there any better options for around the same...
  18. S

    Help with the Cooler Master H500 RGB fans

    Hi, I plan to get the Cooler Master H500 case. It comes with 2x 200mm RGB front fans. I watched whatever videos I could about this case and know that the cables from the fans and RGB cables plug into an included controller, which then plugs into the RGB header on your motherboard. However, I...
  19. S

    [SOLVED] Recently started using AMD StoreMI, today CrystalDiskInfo reports Caution: Uncorrectable Sectors on HDD

    Hi to you all, I started using AMD StoreMI since about a week, combining an OCZ-VERTEX 3 120 GB SSD with a Seagate Desktop ST2000DM001 2TB 7200 RPM HDD. I use this combined space for storing my Kontakt Libraries, for producing music. I need a speedy drive to load those into my Digital Audio...
  20. J

    [SOLVED] Buying work pc.Budget unlimited.

    Budget:$unlimited Includes price of monitor(minimum 4) tv(minimum 8) And everything.