User Profile
RichL579
Copper Contributor
Joined Jul 19, 2019
User Widgets
Recent Discussions
Creating an Oulook distribution list, my first, LOST all the addresses in Outlook Contact
Created a list of addresses using instructions from MS. Add then saved. Now all I get for both icons People and Groups is 1 address and the group. I had MANY addresses in the People folder. What happened. The group does hold the ones I selected for the group.Outlook stopped allowing access to 2nd hotmail account from inside primary hotmail a/c
Up until 2 days ago and for the past several years, my main Outlook mailto:king.stridet@hotmail a/c has always included mailto:email address removed for privacy reasons under Favorites in Outlook. I could select it and it accesses any mail and associated directories in the a/c. A couple days ago when I was trying to address a msg from MS that my account showed some unusual access from CA around San Francisco. I attempted to change my passwords on these 2 a/c's and did so on my main a/c, but something happened when I tried to do it on the bark a/c. NOW the a/c name still shows up under Favorite in Outlook but when I try to select it is shows: "Your account needs attention. Select this account to resolve." and does not respond to selection, i.e. a click. I've looked all over trying to find where I'm supposed to access it and can't find it. Can someone please advise?Re: Excel hanging with HIGH cpu usage trying to copy and insert rows.
Patrick2788 - Thanks for the info on Edge WebView2 Runtime. I've made a note on my support log if I need it in the future. I began rebuilding the sprdsht from scratch doing segmental copy & paste to avoid bringing over anything that might be hidden. It took some time but seems to have eliminated the problem. Attached is the Workbook Statistics data from the OLD and NEW workbooks.Re: Excel hanging with HIGH cpu usage trying to copy and insert rows.
Just ran Excel in safe mode. Still took several seconds to load. Task manager showed 50+% cpu and 95+% memory utilization. This lasted a couple minutes then it populated the Inspection Results Errors screen and the app HUNG there and is still hung but now cpu ~30% & memory ~50% but the app has been hung now for over 20 mins. See screen shots. Is there some way to determine what is causing this? The Errors reported, because the screen is frozen, cannot be accessed. Sorry cannot attach screen images.Re: Excel hanging with HIGH cpu usage trying to copy and insert rows.
Not that I know of. In fact, I don't even know what Office or COM add-ins are. Can I inadvertently trigger such an add-in? Now when I load the sprdsht it takes several seconds to load. I'm just about to do a Safe Mode open on the sprdsht to see what it shows.Excel hanging with HIGH cpu usage trying to copy and insert rows.
Excel continues to show HIGH cpu utilization when I try to copy and insert rows or columns. See screen shots attached. it has been doing this for a long time (over 1 yr.) and I've reinstalled Outlook365 several times. Now it is showing a new msg in Task Manager: Microsoft Edge WebView2 repeatedly. Does anyone know what causes this so I can fix it or change what I'm doing? This high cpu utilization hangs all Excel sprdshts that I have open (in this case only 2) and Outlook as well. Only the Edge browser continues to work. Also you'll see in the attachments, when it does complete it posts and entirely different set of rows which is the entire sprdsht ahs been copied into the original. See: Screenshot 2022-10-13 104030Re: What causes Excel to use excessive CPU time and generate an 'Excel not responding' msg w/each entry?
Sorry for the naming confusion. I'm still working on these and have renamed them from food consumption to nutrition. The ones listed above are the files that I am trying to 'fix'. No luck yet. I don't see any errors but am probably not looking at the right stuff.Re: What causes Excel to use excessive CPU time and generate an 'Excel not responding' msg w/each entry?
Haytham Amairah Attached are the 2 sprdshts I am currently using. One holds the nutrition data that the LOOKUP checks when I add a new entry to the nutrition log. The other is the nutrition log that accumulates the info.What causes Excel to use excessive CPU time and generate an 'Excel not responding' msg w/each entry?
I have a LOOKUP table with ~ 1500 x 10 elements. It contains a list of foods and all the nutritional factors for each. The next worksheet is used to track food consumption by entering the food name. This triggers the LOOKUP pulling in the nutrition info. A serving size factor then adjusts the serving size nutritional factors based on the portion size to show what was consumed. I track this daily so each day has a list of 10 - 20 items consumed. These values are accumulated for daily, weekly and quarterly-average totals. After a quarter the number of elements / LOOKUPS /calculations will top 15,000. After that Excel starts to slow significantly. When I go to add another food LOOKUP, I get the cycling circle and when I look at Task Manager it shows Excel as 'not responding'. it start taking several seconds to accept and calculate the last entry and when I get to a 2nd calendar quarter it can take minutes. I've broken the workbooks to individual quarters but have the same problem. Am I just expecting too much from Excel's ability to do the LOOKUPs and do all the calculations?
