Search the Community
Showing results for tags 'microsoft excel'.
-
Good Afternoon I have a issue with Microsoft Excel 2021 64 bit. I cannot link my files due to personal keys linked to my API's so I will do my best to explain the situation. Basically Excel is using 64 gigs of RAM and keeping it maxed for anywhere between 20 minutes to a hour. I have12 Excel .xlsx files. I have 1 main sheet the uses VLOOKUP/XLOOKUP to pull from the other 11 sheets. 1 sheet contains only my formula's, it helps to keep my other sheets clean. Once its updated I close it out so it does not have to be open. The other 10 excel sheets contain a few hundred API calls to a server using the DATA tab, from web, inserting the html address, and getting inserted into the sheet in a table. The 10 sheets with the API calls once updated are closed so I will only have my main sheet open. Also when updating my 10 sheets with the API calls, they are open only one at a time. The Main sheet and the Formula sheet have 0 issues when there open and being used as intended. The issue is the 10 sheets with the API calls. All sheets have the same issue. Although it is random and does not always occur in the same spot. I separate all my Queries and Connections into folders with 25 API calls each. Each folder having a Macro to refresh them, and a main macro to refresh all of them sequentially. I tried this to see if the problem was caused by refreshing 350 connections at the same time. I will have that macro below. I can manually refresh each folder and sometimes its smooth. It stays about idle RAM usage at 4-6 gigs. Other times it creeps up to 64 gigs maxed steadily and stays there for 20 minutes to 1 hour. Sometimes jumping down to 40 gigs used and going back up. Even after the refresh of the 25 API calls is complete the RAM is still maxed at 64 gigs for a very long time. 20-30 minutes. Sometimes I can use the main macro and everything refreshes just fine with no RAM jump. It might peek at 10 gigs, but this is rare. The macros all work as intended and everything will refresh. On one of my sheets that has 250 queries it can take up to a hour to complete the refresh because the RAM maxes out. When this happens a full sheet refresh will take up to a hour for 350 refreshes. Random thing I noticed. even though its stored on a M.2 it would max my HDD for storage at 100%? I unhooked it and now my M.2 gets hit but nothing as significant. like a couple %. I have googled until my eyes are sore and I am probably just not using the particular keywords to find my solution. Does anyone have any idea why my sheets use so much data when I have no operations being processed? It starts when I refresh my queries but it continues to stay maxed after it is completed. Any help or Ideas is appreciated. Thank You in advance. I have tried -Turning off background downloads -Turning off automatic cell formula refresh -Refreshing the queries in groups of 25 instead of all of them at the same time. -reinstalling excel -restarting the computer -Turning off Type detection -Clearing the cache (Main macro refresh all) Sub Refresh() Refresh1 Refresh2 Refresh3 Refresh4 Refresh5 Refresh6 Refresh7 Refresh8 Refresh9 Refresh10 Refresh11 Refresh12 Refresh13 Refresh14 End Sub Sub Refresh1() ' ' Refresh1 Macro ' ' ActiveWorkbook.Connections("Query - TAIT").Refresh ActiveWorkbook.Connections("Query - TAOP").Refresh ActiveWorkbook.Connections("Query - TAP").Refresh ActiveWorkbook.Connections("Query - TBLT").Refresh ActiveWorkbook.Connections("Query - TC").Refresh ActiveWorkbook.Connections("Query - TCN").Refresh ActiveWorkbook.Connections("Query - TEO").Refresh ActiveWorkbook.Connections("Query - TER").Refresh ActiveWorkbook.Connections("Query - TJX").Refresh ActiveWorkbook.Connections("Query - TKC").Refresh ActiveWorkbook.Connections("Query - TRI").Refresh ActiveWorkbook.Connections("Query - TRKA").Refresh ActiveWorkbook.Connections("Query - TRNS").Refresh ActiveWorkbook.Connections("Query - TSEM").Refresh ActiveWorkbook.Connections("Query - TTCF").Refresh ActiveWorkbook.Connections("Query - TTMI").Refresh ActiveWorkbook.Connections("Query - TXRH").Refresh ActiveWorkbook.Connections("Query - UBCP").Refresh ActiveWorkbook.Connections("Query - UEPS").Refresh ActiveWorkbook.Connections("Query - ULTA").Refresh ActiveWorkbook.Connections("Query - UMC").Refresh ActiveWorkbook.Connections("Query - URBN").Refresh ActiveWorkbook.Connections("Query - VC").Refresh ActiveWorkbook.Connections("Query - VCR").Refresh ActiveWorkbook.Connections("Query - VHC").Refresh End Sub (Seperate Refreshes) Sub Refresh2() ' ' Refresh2 Macro ' ' ActiveWorkbook.Connections("Query - TRI DIV/YIELD").Refresh ActiveWorkbook.Connections("Query - TXRH DIV/YIELD").Refresh ActiveWorkbook.Connections("Query - UBCP DIV/YIELD").Refresh ActiveWorkbook.Connections("Query - UMC DIV/YIELD").Refresh ActiveWorkbook.Connections("Query - VCR DIV/YIELD").Refresh ActiveWorkbook.Connections("Query - VHC DIV/YIELD").Refresh ActiveWorkbook.Connections("Query - VSH DIV/YIELD").Refresh ActiveWorkbook.Connections("Query - WIT DIV/YIELD").Refresh ActiveWorkbook.Connections("Query - WSTG DIV/YIELD").Refresh ActiveWorkbook.Connections("Query - YUM DIV/YIELD").Refresh ActiveWorkbook.Connections("Query - WTBDY DIV/YIELD").Refresh ActiveWorkbook.Connections("Query - SILC HIS").Refresh ActiveWorkbook.Connections("Query - SIMO HIS").Refresh ActiveWorkbook.Connections("Query - SISI HIS").Refresh ActiveWorkbook.Connections("Query - SLAB HIS").Refresh ActiveWorkbook.Connections("Query - SMCI HIS").Refresh ActiveWorkbook.Connections("Query - SMGZY HIS").Refresh ActiveWorkbook.Connections("Query - SMTC HIS").Refresh ActiveWorkbook.Connections("Query - SNTG HIS").Refresh ActiveWorkbook.Connections("Query - SOFO HIS").Refresh ActiveWorkbook.Connections("Query - SOMLY HIS").Refresh ActiveWorkbook.Connections("Query - SPKKY HIS").Refresh ActiveWorkbook.Connections("Query - SRAD HIS").Refresh ActiveWorkbook.Connections("Query - SRI HIS").Refresh ActiveWorkbook.Connections("Query - SRT HIS").Refresh End Sub Ryzen 5900X 64 Gigs 3200 Memory X570 Meg Ace 1080ti 1TB Samsung EVO M.2
- 2 replies
-
- microsoft excel
- microsoft office
-
(and 1 more)
Tagged with:
-
We have 2 Macbooks who haved shared acces to the xlsx documents. If User 1 opens the file to edit, then when User 2 opens the file aswell it should give them a "read only" warning. This is no longer happening. They can both open and edit at the same time, and then When they save the file, they overwrite eachother's data, losing one of the two's in the process. Any idea on how to fix this issue and to return the "read only" part for user 2. We are using a NAS with AFS protocol to share the documents. it affects all the macs, it does not affect the windows users. It occurred after the upgrade from office 2011 to office 365 2016. The Detailed build number for the mac's is: 16.13.1 (180523) Updated to build nr: 16.14.0 (18061000) The new update did not solve the issue. On first time opening after update, the issue was resolved, but from the second time on, issue returned as it was. Kind regards, Shane
-
Hi, I've got the below line chart How do I bring the 4 line series closer together, so there is a huge gap between them Thank you
-
Hi guys! I know I keep bothering you about Excel, and this is not an Excel forum, but I have one more question. Can I set in a formula to automatically change the color of the output text in the cell under a certain condition? For example: I want to take the hourly rate from one cell and add the total tips received (net) from another cell, then divide by the number of hours worked to get the effective hourly rate when including net tips. The formula is =L17+J17/K17. One problem, this unnamed job has certain costs the worker must pay for, and the employer expects the employee to make up those losses from his or her tips. This usually skims some of their tips away, but on rare occasions if the tips are too low, the worker could actually lose money. If the net tips after expenses are a negative number, the new hourly rate would be less than the original hourly rate. So how could I tell Excel to preform the function =L17+J17/K17, and if the output is less than L17 change the output text color to red? Thanks! -Jason
-
Hi guys, I have a formula in a cell =(F2-G2) and I want to tell the cell to round to the nearest hundredth. I Googled it but the formula examples I saw had multiple cells, say one cell giving the raw output and a second cell rounding that other cell's output, I just want one cell to preform my formula then round the answer. How do I do that? Thanks, Jason.
-
So there were a lot of issues with my laptop. So many that everyday a new problem would pop up. I got so annoyed that several times I was on the brink of smashing my laptop with my dad's sledge hammer. I realized that I probably did something at some point in the past to screw up my laptop this bad, so to be safe I installed Avast, Malwarbytes, Spybot and Norton to see if this was the work of a virus or any type of malware and I got nothing. Then I looked online ways to improve performance and how to fix it and how to detect problems with my laptop. I tried everything those webpages said, but my laptop was still garbage. Whenever there was a problem I would look online search ways to fix it, reading sites and forums like this one, but there were too too many issues to try and fix all of them so I said "Fuck It!" and decided to use the refresh option for my laptop. I had already backed up my stuff but it only allowed me to back up my personal files (music, videos, downloads documents etc.) so I copied and pasted all of the program files and program files (x86) to the file history folder in my hardrive in hopes that I get to have all of my programs and their relative files that help it work. I couldn't find any option to restore these files back into my computer so with programs and program files (x86) I copied and pasted them back into their respected folders on my laptop and "copy and replace" whatever was already in those folders. Now I have some programs back but others are missing, and when I do find them I can't find the executables or the files that'll allow me to open the programs. For example I tried looking for visual studio but couldn't find it anywhere, I found microsoft word, excel, powerpoint and onenote but I can't open them. They have different names than Microsoft Word or Powerpoint, their names are "winword, powerpnt, onenote, and excel". Excel and OneNote have the proper names but word and powerpoint do not. Not to mention the size of them besides excel is suspiciously small. So those may not be the programs but I couldn't find anything else. Other programs that I found are there but I can't open them or give me some error message. Can anybody please help me find my programs, and how to open the ones I found (Especially the microsoft office ones)? Can you also tell me where I went wrong,? I'm thinking it was the program files and program files (x86) copying. I am also not sure if I backed up properly either. I used file history but is there a better and more thorough way? Known issues: - Boot up would take so long sometimes it would boot up for an hour which is around the time I do a force restart. - When it does boot up the screen turns black and stays until I left click the trackpad or wait for an hour. -> I heard if you disable some startup programs it boot faster which I did but am still getting the same problem. - The start menu won't open and neither would notifications. - Overall slow when doing anything. So slow I wanted to claw my eyes out whenever I used my laptop. - End up having to do 4-5 force restarts a day. - Applications take a LONG time to open and half the time they never open at all. - The taskbar would stop responding and freeze - All of my programs would constantly say "not responding" - In task manager the CPU hits 99% most of the time if not it stays at 89%, the memory is always above 80%, the Disk stays at 100% even though I have like over 100 GB of free space. This laptop is going crazy, and this is with only a 3 or 4 apps open. These issues are only what I can remember at the moment but like I said everyday there's a new issue. Laptop info: Lenovo Yoga 2 11s Processor: Intel® Pentium® CPU N3530 -> 2.16 GHz RAM: 4GB OS: WIndows 10 (64-bit)
- 8 replies
-
- refresh pc
- windows
- (and 8 more)
-
Can anyone please help, I want to scan a barcode for a bus and then I want it to automatically go down the list to the bus number that I scan and go across to the comment cell. This will make my job so much easier when I check buses I don't have to manually select the comment cell. Please help
-
Looking for a cheap laptop for my mom for office related stuff like excel and word. Mass editing of document scans with Office Picture Manager. Being lightweight is the most important factor. Preferably around 3lbs. The cheaper the better, hopefully everything will be less than $500 USD. Preferably from Newegg or Amazon but not required. Probably going to replace the hdd in it with a ssd or sshd and wiping everything with fresh reinstalls of Windows and Office. Looking at laptops now and I'm likely to post some links as I find them. Edits: Looking at these two right now ASUS X200CA-DB01: http://www.newegg.com/Product/Product.aspx?Item=N82E16834314135 Acer Aspire C710-10074G01ii: http://www.newegg.com/Product/Product.aspx?Item=N82E16834231117 Not sure if the 1.5ghz celerons are powerful enough though. I have an extra 2GB stick of ram lying around for if I get the Asus notebook. Edits: Turns out 1.5ghz is enough. If anyone can find a cheaper solution, that would be nice. Otherwise, a vote would help sway my decision.
- 24 replies
-
- lightweight
- light
-
(and 5 more)
Tagged with: