Excel

Currently my work system is a frankenstein build I scrounged from existing workstations at my job and comes to a halt whenever I throw processing for our monthly data every month. Current spec is an i7 7700 and 24gb of random ddr4 i could steal from old workstations. Unfortunately the whole...

Hello all, I have an excel sheet with a list of employees and what shirts they want, columns include size, color, gender and quantity. The main problem with this is that some cells under these columns may have multiple items (ex: one Color cell has Black, Blue). How can I make it so that it...

Hi all, I have a couple of end users who have issues with specific shared excel files on our network drive. They are .xlsx files and everyone should be on version 2308 of Excel. One file has macros, the other does not. Only one user is allowed at one time. 50/50 chance of the files opening...

Hello I have migrated my excel software from my Windows 7 PC to a Windows 11 PC. Two weeks into and everything ok. All my vba was working and my addin (structuralVBA.xlam) was ok. Then I imported a workbook from my archive and that workbook referenced the same add-in but at a different...

Hello I am using the latest Excel on a Windows 11 PC. I hace created a UserForm and when I try to hide the userform I get the following error. - "Run-time error '402' Must close topmost modal form first" Looking on the Internet I get the advise that something broke in my PC when I had a...

Trying to print multiple copies of thermal paper from an EPSON TM T88V on Excel. I have tried multiple different printing options and nothing seems to work. I ask for 10 copies and it will only print one. Anyone know what's going on? I assume they might not be compatible.

Hi guys My boss at work was experiencing slow performance with his old system in Excel 365, using Windows 10. I've just built him a new PC and it's still just as slow. The new system is a 12th Gen i7 with 64gb RAM, decent SSD and quality Asus mobo. The only part that isn't that great is the...

Dear Community, We have this User who had system with Office 2013 Suite Installed and all his files were synced on onedrive sand he could easily create Charts but when his system stopped working then we gave him new system with office 2016 installed. The Issue now is that when he tried adding...

Hello! I need some help with my Excel file. I cant access it at all, cant move or copy it or anything. When i worked at my previous company i made an excel file with private and personal info with accounts and passwords and stuff to be safe i made the workbook passwordprotected, ( i know the...

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...

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...

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...

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...

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...

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...

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...

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...

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?

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.

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

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...

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...

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

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

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...

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...

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...

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.

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...

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...

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

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...

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...

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...

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

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

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...

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...

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) /...

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...