Excel

Forum discussion tagged with Excel.
  1. A

    Question Excel data type changed by itself when using Pivot?

    Hey! So I have an excel datasheet which uses PowerPivot to import data from a plain txt file. One of the columns is just dates. I have set the date format in the Pivot editor interface, but for some reason every new entry added to the txt file (same format as all the other ones), the dates...
  2. I

    Question Excel Find/Replace performance

    I have a spreadsheet with about 320,000 cells. Those cells contain formulas like ='R:\Basketball\[Ref Stats v8.xlsx]Analysis Data'!$t1465 I reference all external content only in one sheet and all others work from that data so other sheets don't have to use external references. Pretty basic...
  3. dradenpoel

    [SOLVED] lookup and list items with same value & related info

    Hey all, I am making a spreadsheet for making internal coupons. File can be found here: https://drive.google.com/file/d/1Q8qpeDQcD9S7dSXDnW8I_ZoMNMGX3Ma5/view?usp=sharing In short; I have cols that contain info about what's moved, in one of the cols I put a coupon number/name. In another tab...
  4. JunkSniperJoe

    [SOLVED] Issues with Office: text disappears for a second in Word

    I'm not sure if this is the best place to ask this, but I thought I give it a shot. For a while now, my office installation has been a bit weird, Word especially. When I type letters temporarily disappear, then come back when I'm done typing. My other Office applications don't have this issue...
  5. Knova3

    [SOLVED] Google Sheets - Formula to find difference between two values and recognize if the number difference is positive or negative

    Hope my blabbering will make sense to someone. I'm trying to create a spreadsheet in Google Sheets to record profits and losses. I've used the =ABS(A1-A2) formula to get the differences in between two cells values, but I've noticed that it doesn't recognize negative number differences. For...
  6. J

    [SOLVED] Google sheets/excel help

    Hi guys! I was just wondering if anyone knew a formula that I could use to get my spreadsheets on excel/or docs Better, on sheet 1 I have a list of tasks with codes, descriptions and prices, on Sheet 2 I have a job sheet where I would like to be able to put in the job code and then it...
  7. noyaus

    [SOLVED] 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...
  8. J

    [SOLVED] 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...
  9. O

    [SOLVED] 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?
  10. 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.
  11. 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
  12. 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...
  13. 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...
  14. 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.
  15. osama_moussawi

    Discussion Laptop for Large Excell files

    Hi What is the best Laptop Specs (CPU) for processing large excel spread sheets files!
  16. 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...
  17. 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...
  18. 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...
  19. 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.
  20. 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...
  21. 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...
  22. M

    Dual Link DVID to HDMI

    help, do i need active adapter or passive adapter for my Powercolor RX570 4gb.
  23. 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...
  24. 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...
  25. 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...
  26. J

    [SOLVED] Buying work pc.Budget unlimited.

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

    Liquid cooling compatibility

    I am currently running a closed loop cpu cooler and will be getting a water block for my gpu, is there a way to connect the reservoir pump (gpu) and the cpu pump into the motherboard (2 loops) or will I need to get a new cpu water block and radiator to just have 1 big loop. Thanks
  28. B

    is it okay to power i3-7100 using a 6pin-to-8pin adapter for the motherboard?

    So my 400w power supply (SeaSonic SS-400ET) comes with 1x8 pin connector that I'll be using to power my RX 570, but I realized that my motherboard requires 8pin connector to power the CPU, my question is would it be fine to use a 6pin-to-8pin connector that I have laying around to use on the...
  29. L

    [SOLVED] i7-3770 CPU upgrade to support VR?

    I was curious if there was an affordable option available for this. I'm interested in just playing games like VRChat and maybe (very much a stretch) Beat Saber VR, but when I checked my system using the SteamVR Preformance Checker, it said my CPU was holding me back, not my Graphics Card. Which...
  30. J

    New Build €1200 quick check

    Hi, can you guys quickly check over this new build for a €1200 gaming PC. Will be running RPGs, not fast shooty games. I just want to make sure all the bits fit together and I'm not missing anything obvious or clever. Thanks. [PCPartPicker part list](https://ie.pcpartpicker.com/list/7PmqQZ) /...
  31. S

    Is 8gb ram enough for 1080p ultra/max settings?

    Hey guys, so basically I'm getting a brand new PC hopefully by next year (Or Christmas if I'm lucky) and I'm wondering if 8gb ram is enough for 2018's standards. Games like Black Ops 4 that I would love to play have a recommended system requirement of 12gb of ram and I'm worried that it just...
  32. T

    Testin DRAM with Prime95

    Can i test my DRAM using Prime95. If yes then how and can it be done using some patterns or generating patterns
  33. S

    intel 8th gen motherboard with ECC support

    I'm running a server which needs ECC memory. my cpu is intel core i3 8100 which supports ECC memory (I even confirmed that when I contacted intel's support) the problem is finding motherboard that supports ECC memory (I prefer it to be z370) do such motherboard exists ? my current motherboard...
  34. V

    Computer began running cmd.exe and running downloads on its own

    I was away from my PC for about 3 minutes, and when I came back to it items were opening and closing fast. It looked like a couple cmd prompt items ran and when I was it open Run i shut off the PC immediately. I started it back up and looked at the Run history and saw "SystemPropertiesAdvanced"...
  35. S

    How do you adjust the record meters on my nakamichi CR-4 when the record meters stay on before recording tapes?

    Hers the thing: I have a rare nakamichi CR-4 tape deck that works nicely but the record meters are on at the -30 on both L/R channels when they should be off when you want to record your tapes. Is there an adjustment for this inside of the unit to eliminate this? Let me know soon and schematics...
  36. F

    My Cpu spikes to 100 anytime i play a game.

    Just looking for ways to trouble shoot this.
  37. R

    Restore Microsoft edge original theme

    A while back I saw a YouTube video on how to change Microsoft edge look, it looks cool but now I want the old edge back, my edge is stuck looking like this
  38. J

    Are these screen brightness nits number correct?

    Ran across this article and it starts out by saying 300 nits is very bright yet the brightest in the list is 209? I read lots of reviews on Notebookcheck and typically all the units they review are in the 175-275 range. These numbers look very low to me. Granted I might not be comparing...
  39. V

    Detachable headset MIC not working

    I am currently using a RIG 400hs headset (which has a detachable mic) and I have attempted to fix this problem but my laptop doesn't seem to have recognised the microphone. I have tried going into the audio devices but i couldn't find it, i am very confused and don't know what to do. Also it...
  40. J

    compatibility issues with Gigabyte H61MA-D2V and rx 460

    hi there i recently brought a Rx 460 used for my PC to upgrade from my HD 6670 1GB when i went to collect i made sure to see the card working and the seller installed it into a PC and show it working using the HDMI fast forward to back home and i'm installing it into my PC and everything is...