Forum Widgets
Latest Discussions
Excel College Student SOS
Hey! College student here. I've been jumping through hoops trying to understand Excel. I'm not sure if Microsoft Excel has changed because this is my first experience with the whole ordeal. The homework given from my (ACG Excel class basically) has me following directions and I can't find the Smart Lookup tool in the Review tab??? There are so many features I cannot simply find in the Ribbon. Also, the Ribbon looks different. Not necessarily like the original. Someone please help me out of my misery.greensidegoldJul 11, 2025Occasional Reader23Views0likes1CommentIrregular date calculations in large spreadsheet
I've been managing finances for a long time now in Excel. It has grown to 11.500 lines over a period of 20 years en recently my date calculations start to give #VALUE outcomes. The formula in line 11498 is "=ALS(H11498<>"";H11498+7;D11498+14)" The field H11498 contains a date (25-6-2025) and has cell characters of a date. Similar formula in 11497 works like a charm. 11498, 11499 and 11500 give #VALUE 11501 works like a charm again. Any ideas? Have I run out of Excels possibilities in regards to the size of the spreadsheet?Remko77Jul 11, 2025Copper Contributor42Views0likes3CommentsInvalid procedure call or argument (VBA Error 5 Excel) in Build 19011.20000
Version 2507 (Build 19011.20000) gives the following VBA error in Excel: "Invalid procedure call or argument (Error 5)" It stops at the following line in VBA: === qv_wiel = WorksheetFunction.Min(3 * wiellast / (2 * Pi * Sqr(Sqr((x_wiel - x0) ^ 2 + (y_wiel - y0) ^ 2) ^ 2 + H_eq ^ 2) ^ 2) * Cos(WorksheetFunction.Radians(WorksheetFunction.Degrees(Atn(Sqr((x_wiel - x0) ^ 2 + (y_wiel - y0) ^ 2) / H_eq)))) ^ 3, wiellast * 4 * (1 / 4 - 1 / (2 * Pi) * (WorksheetFunction.Asin(2 * H_eq * Sqr((4 * H_eq ^ 2 + L_strook ^ 2 + B_strook ^ 2) / ((4 * H_eq ^ 2 + L_strook ^ 2) * (4 * H_eq ^ 2 + B_strook ^ 2)))) - 2 * H_eq * L_strook * B_strook / Sqr(4 * H_eq ^ 2 + L_strook ^ 2 + B_strook ^ 2) * (1 / (4 * H_eq ^ 2 + L_strook ^ 2) + 1 / (4 * H_eq ^ 2 + B_strook ^ 2)))) / (B_strook * L_strook)) === This issue didn't exist in Version 2506 (May 2025) and lower.SolvedwiensJul 11, 2025Copper Contributor118Views0likes6CommentsAssistance with Pivot table mapping
I'm needing help with formula i created im trying to have my table show employees with potential 1-3 to return on 9 box bottom left box and unsure if i need a whole new formula as my current is not retuning nameskal2kalJul 11, 2025Copper Contributor72Views0likes1CommentCreate an Excel-based form that is instanced for each user and connects to Power Automate
I'm trying to standardize and simplify a process at my job because we receive the request type in the picture in several different formats via email and there are no parameters for the fields, so we end up with a lot of garbage/incorrect entries that we need to clean up every week. While I've used Excel in all my office jobs, I'm not as versed in it as this task seemingly requires. What I have so far is the form below, which can be "submitted" with all the relevant data being written to a separate sheet. Ideally, if possible, managers would access this form through our company Sharepoint and only be able to view an instanced version unique to them, so multiple users could theoretically access the form and submit requests at the same time without seeing others' entries. Then whatever data they enter would be written to a separate Excel sheet/workbook that only the relevant team can view, where payment amounts are split into different lines based on Job and Sub Job. The ultimate goal would then be to have Power Automate put together an Excel spreadsheet that we can upload into our ERP. If we can automate this process to a point where we just need to check for accuracy, we'd save hours every week. Is what I'm trying to do even possible with Excel, and if not, is there a better avenue in the Microsoft Office suite? I would love to be pointed in the right direction so I can research and learn. I've looked into making a Microsoft Forms version of this sheet, but it seems more suited to simpler form entries, at least as far as I can tell.soupeaterJul 11, 2025Copper Contributor68Views0likes2CommentsHow to automatically login and refresh a spreadsheet using a plug-in?
Hi. I have a requirement to automatically refresh a spreadsheet's data. I'm an Excel novice and have no idea how to do this automatically. To refresh the data in a manual fashion, I perform the following steps: 1) Open the Excel file. 2) Click on the iLEVEL menu option (it's on the top amongst other menu options such as 'Data', 'Review', Automate', etc..). This will present an iLEVEL login icon. Click on this icon and then enter my email address and password. In fact, once I've entered my work email, it uses SSO to gain access instead of entering a password. I do have a password should I need it (needs to be entered somewhere). 3) On the toolbar ribbon, under the iLEVEL menu option, there is the 'Refresh All' option. I click on this, wait a few minutes, and the spreadsheet has its data refreshed. iLEVEL is a third-party software solution. What I need to do is to achieve the above result automatically. At, say, 3am each morning, I would like automatically refresh the data. So there is the need to not only automatically login and refresh the data, but also to schedule the data refresh. The updated spreadsheet will then act as the data source for our reporting. In case it's asked, at this time, we cannot look to hook into the view/table that feeds this spreadsheet. Therefore, the spreadsheet is the endpoint. I will investigate this but if you are aware if this can be done or not, and point me in the right direction, it will be appreciated. I'm wondering if Power Query, or something similar, could achieve this. Thanks.35Views0likes2CommentsHow to automate a login and refresh of a spreadsheet via an Excel plug-in?
Hi. I have a requirement to automatically refresh a spreadsheet's data. I'm an Excel novice and have no idea how to do this automatically. To refresh the data in a manual fashion, I perform the following steps: 1) Open the Excel file. 2) Click on the iLEVEL menu option (it's on the top amongst other menu options such as 'Data', 'Review', Automate', etc..). This will present an iLEVEL login icon. Click on this icon and then enter my email address and password. In fact, once I've entered my work email, it uses SSO to gain access instead of entering a password. I do have a password should I need it (needs to be entered somewhere). 3) On the toolbar ribbon, under the iLEVEL menu option, there is the 'Refresh All' option. I click on this, wait a few minutes, and the spreadsheet has its data refreshed. iLEVEL is a third-party software solution. What I need to do is to achieve the above result automatically. At, say, 3am each morning, I would like automatically refresh the data. The updated spreadsheet will then act as the data source for our reporting. In case it's asked, at this time, we cannot look to hook into the view/table that feeds this spreadsheet. Therefore, the spreadsheet is the endpoint. I will investigate this but if you are aware if this can be done or not, and point me in the right direction, it will be appreciated. I'm wondering if Power Query, or something similar, could achieve this. Thanks.AzureNewbie1Jul 11, 2025Copper Contributor27Views0likes2CommentsShortcuts to favourite formats in Excel for Web
We're switching to excel for web more and more. In my desktop excel, i have 6-8 favourite formats stored as simple macros, and short cut buttons in the quick access toolbear It makes it really easy to tidy up worksheets. Is there a way to achieve the same within excel for web? I know i can't add macros, but quick access to favourite formats makes life much easiertespo76Jul 11, 2025Occasional Reader10Views0likes0CommentsSumifs or other solution for both vertical & horizontal criteria
Hi all, I would like to sum values from a matrix of vertical critiera (e.g. names) and horizontal ones (dates as well as other criteria). I am not sure the sumifs formula can actually do this. So far I am getting errors. Hence, I would be very grateful if someone had another simple way/ formula to have the results calculated. Example is as such: Criteria 1 (vertical): Names Criteria 2 (horizontal): Date (1st row) Criteria 3 (horizontal): "Plan" (only) i.e. (2nd row) Sum-up values: In the empty cells in the matrix of the 3 criteria 1st May 25 1st Jun 25 1st Jul 25 1st Aug 25 1st Sep 25 Actual Actual Plan Plan Plan Name 1 Name 2 Name 2 Name 3BFKJul 11, 2025Copper Contributor214Views0likes13CommentsNot carrying formatting over
I wonder if someone can solve this one for me... I have multiple workbooks, each with summary sheets. Someone here kindly helped me make a formula so I can mirror all the summary sheets into one workbook. The only problem is that the summary pages are all formatted perfectly but when I use the below formula it doesn't carry of this across. Is there a way that I can do this? I've pasted the formula below =LET(range,'https://retailstarbucks1com.sharepoint.com/sites/M23Corridor/Shared Documents/General/Labour/[Purley.xlsx]Quarterly Summary'!A1:Q31,IF(range="", "", range)) Thank you!!jmcintosJul 10, 2025Copper Contributor30Views0likes1Comment
Resources
Tags
- excel42,906 Topics
- Formulas and Functions24,891 Topics
- Macros and VBA6,451 Topics
- office 3656,098 Topics
- Excel on Mac2,665 Topics
- BI & Data Analysis2,405 Topics
- Excel for web1,943 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,658 Topics