Forum Widgets
Latest Discussions
Irregular 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 10, 2025Occasional Reader19Views0likes1CommentNot 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 Contributor20Views0likes1CommentHow 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 10, 2025Copper Contributor14Views0likes1CommentAssign a unique 4 digit pincode
Hello Excellers, Is it possible to assign a unique 4-digit pincode to every new row? Use: to create a list of cashiers (add and delete as they come and go) and let Excel create the pincode that they need for the cash register. I can make up one for each cashier but since we have hundreds there is a risk to create doubles. I've tried with RANDARRAY but several attempts were unsuccesful. YT shows some results but not quite what I need. Help is much appreciated! Greetings, StevenSteven De BlockJul 10, 2025Copper Contributor29Views0likes1CommentCumulate percentage returns.
Hello, I have investment returns which I would like to cumulate. I have positive and negative returns in percentage figures. I am struggling to find the formula, i.e. GEOMEAN doesn't work well with negative returns. I apprecieta every tips and hints! Best wishes, PascalPascal_KJul 10, 2025Copper Contributor70Views0likes3CommentsDuplicated named ranges on sheet copy
Hello all, I have spent a couple of days building an excel workbook that is used by technical staff to calculate manufacturing/costing data. The book contains a master data sheet with a number of tables and a number of named ranges (global in scope) from columns in the tables. There is a master calculation sheet that users would copy/rename and then edit. Data in the master data sheet tables and items in the named ranges are then used in (auto-populated) formulas to calculate outputs. Everything works great! except.............. Every time the master calculation sheet (or a sheet previously created from a copy) is copied, Excel duplicates the named ranges (scoped to the new sheet). If I could simply stop Excel creating new named ranges all would be well!! I have done extensive reading, and it seems this is normal behaviour? I have seen solutions including manually deleting the new named ranges, to using vba to copy a sheet and then remove all sheet scoped named ranges, but everything seems a 'hack'. Is there no way for me to stop Excel creating these locally scoped ranges at each sheet copy? ThanksSolvedITTom365Jul 10, 2025Copper Contributor7.4KViews0likes7Commentserror bars not transferring when switching row/column in excel
Hello. I created a clustered column bar chart with error bars (using the custom option). However, when I "switch row/column" only some of my error bars are included on the new chart. Is there an easy fix to this? Thank you!PinaHolwayJul 10, 2025Copper Contributor405Views0likes2CommentsCalculate Due Dates, excluding Holidays and Weekends
Hello all! I would like to calculate a due date, excluding holidays and weekends. This is my data: The "COH Due" column is being manually entered, but I want it to be automatic. So, starting from whatever day is in the "Date Accepted" column, I want to add 7 business days to it. I'm not sure what formula I would need for that. Any help would be greatly appreciated. Thank you!Solved175429Jul 10, 2025Copper Contributor127Views0likes8Comments
Resources
Tags
- excel42,904 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,942 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,658 Topics