Missing Stock Jio Financial Services in Excel Stocks Data Type
Hi! The stock Jio Financial Services Limited listed on Mon 25-Aug-23 (NSE symbol: JIOFIN). But this is missing in Excel. When I enter JIOFIN.XNSE and try to convert to a Stocks Data type, it says not found. Kindly update your Stocks database. VS
macro not avaliable in this workbook
1: Check whether Excel has blocked the macros Close the workbook. Open File Explorer and locate the .xlsm file. Right-click the file and select Properties. On the General tab, look at the bottom for a Security message with an Unblock checkbox. If it appears and you trust the file, check Unblock, click Apply, then OK. Reopen the workbook. 2: Enable macros in Excel Open Excel. Go to File → Options → Trust Center. Click Trust Center Settings → Macro Settings. Choose an appropriate setting that allows the workbook's macros to run, subject to your organization's security policies. Avoid enabling all macros globally. Click OK and reopen the workbook.Put multiple values in one cell with lists and arrays in Excel
Throughout Excel's 40-year history, you've only been able to put one value per cell. In this announcement, we're excited to share how that's changing with the release of lists, arrays in cells, and nested arrays, initially to Microsoft Excel for Windows and Mac Beta Channels. Many workbooks already try to pack multiple values into one cell. A project might list "Carlos, Henrietta, Jacob" as three owners, or a Forms survey might return "2:00 PM; 2:30 PM; 3:00 PM" as one response. With lists, you can keep those values in one cell, while also keeping them separate for filtering, calculation and more. Later in this post, we'll explore arrays in cells and nested arrays in more depth. NOTE: These are preview features. Their behavior may change before general release based on your feedback. We don't recommend using them in important workbooks until they're generally available. Lists Lists let you put multiple values into one cell. You can create a list by selecting Insert > List or pressing Ctrl+J, then typing or pasting items separated by commas or semicolons, depending on your regional settings. Selecting the icon in the cell shows the individual values. You can add, remove, or edit list items by double-clicking the cell or pressing F2, just like other values. With lists, you can filter by one or more individual items instead of whole text entries. Referencing a list returns all its values for calculations. For example, =B2 spills those values into separate cells. Arrays in cells Lists are useful on their own, but they're part of a much broader change to Excel. For the first time in Excel, arrays can exist natively in cells as values or as formula results. They can be any size or shape and can even contain other arrays. You can now keep the result of any spilling formula in a single cell by "wrapping" the formula body with braces { }. Since the introduction of dynamic arrays, array results have spilled across cells – for example ={1;2;3}. Wrapping the original array with braces creates a 1x1 array around it, so instead of spilling to multiple cells, the array stays in a single cell. Braces have long been used to describe arrays in Excel and this extends that behavior by allowing multiple layers of braces. This gives you more flexibility when building spreadsheets. Instead of leaving room for a formula to spill, you can keep the result in one cell. Arrays inside arrays, or nested arrays Arrays can now also "nest" inside other arrays. For example: ={{1,2,3};{4,5,6}} Previously, a formula that produced an array of arrays would return a truncated result or #CALC! error. Now, supported formulas return the complete nested result. In the example below, you can see how TEXTSPLIT behaves with and without nested arrays. Without nested arrays, Excel only returns the first item for each row. With nested arrays, the result spills, one array per row. The arrays in each row can then be used in further calculations. Four new functions: FLATTEN, HAS, HASANY, HASALL To help you work with arrays more easily, we've added four functions. FLATTEN(array, [pad_value], [levels]) simplifies nested arrays by removing one or more levels of nesting. Continuing from the prior example, FLATTEN lets you simplify the nested array output, spilling the individual results into the grid. We used an empty string ("") for pad_value so rows with fewer items show blanks in the remaining columns. Three HAS functions check whether values are in an array: HAS(array, value) returns TRUE if value appears anywhere in array, and FALSE otherwise. HASANY(array, values) returns TRUE if any of the values appear anywhere in array, and FALSE otherwise. HASALL(array, values) returns TRUE if all of the values appear anywhere in array, and FALSE otherwise. Do more with spreadsheets using arrays in cells and nested arrays Arrays in cells open up spreadsheet designs that weren't practical before. The run tracker below captures split times (how long it takes to run each kilometer) in a table with one run per row. The number of splits depends on the length of the run. Stats for each run are calculated right in the same table. For more examples, I recommend looking to your favorite Excel communities on LinkedIn, YouTube, Reddit, or elsewhere. Enabling nested array calculations in a workbook Compatibility Version 3 will be released alongside arrays in cells and is required for most calculations involving nested arrays. You can set Compatibility Version for each workbook in by selecting Formula > Calculation Options. See compatibility versions for more information. Some existing formulas return different results in Compatibility Version 3. If your workbook doesn't behave as expected, you can keep it set to Compatibility Version 1 or 2. Known limitations As this feature rolls out to Beta Channel, the following limitations apply: Conditional formatting doesn't inspect array contents unless you use a formula Data validation can't use a list or array as dropdown items Charts don't expand an array into data points PivotTables don't read array values as source data Power Query doesn't load or emit array-valued columns Find & Replace can't replace list/array items Availability These improvements are rolling out to Beta Channel users running: Windows: Version 2610 (Build 20520.20000) or later Mac: Version 16.114 (Build 26092111) or later Features covered on this blog roll out over time to enable us to monitor quality and performance, so some preview features may not be available to you right away. Also note that features may be paused, adjusted, or removed as part of that process. Feedback Click Help > Feedback in Excel to tell us what you think.Excel 365 64-bit: Out of memory when editing VBA in an existing XLSM
Hello, Microsoft Support referred me to this community because they could not resolve an Excel VBE editing issue. Environment: Microsoft 365 Excel for Windows, 64-bit; Version 2610, build 16.0.20527.20088; Existing macro-enabled workbook (.xlsm); Calculation mode: Manual. Problem: While editing an existing standard VBA module, typing: Dim testeCompilacao As Long and pressing Enter triggers “Out of memory.” Adding a new procedure also triggers the error. This occurs before compiling or executing any macro. In a new blank workbook, I can create a VBA procedure normally. Tests already completed: Office Quick Repair: the error persists; Excel Safe Mode: the error persists; Checked VBA references: none marked MISSING; Tried another existing standard module: the same error occurs. A preserved version of the workbook previously compiled successfully and opened without a repair warning. The workbook contains 46 worksheets, 12,485 formulas, VBA and CustomXML used to persist scenario data. These elements must be preserved during troubleshooting. Support suggested importing native module exports into a separate new XLSM, without copying worksheets. That isolation test has not yet been completed. What diagnostic steps can distinguish an Office/VBE build or installation issue from a problem within this specific VBA project? What logs or additional evidence would help identify the cause? I can provide screenshots of the error and the Excel version. The complete workbook contains proprietary code and data and is not suitable for public posting. Thank you.
Excel 4.0 macros are not working properly after last update Oct 2026
One of the functions I use in the name manager Eval1=LAMBDA(x,IF(TODAY(),EVALUATE(x),)) has stopped providing results. It only returns #NAME? as result. I have been using it for years without a problem and the last update (Oct 2026) I believe was the source of this issue. I have already checked the settings in the Trust Centre and are fine.Excel 2016 & 2019 - Conditional Formatting Affecting Pasting with Formats
As of this week, I'm having a problem with conditional formatting preventing me from pasting copied cells with any paste options that include formatting. This issue is occurring on three Win 10 and 11 computers with Excel 2016 and/or Excel 2019. For example, I can open a new excel workbook, input data into cells, format the cells and then copy and paste to new cells with the formatting pasted. But if I add conditional formatting anywhere in the sheet, I cannot paste any cell (with or without the conditional formatting) when formatting is included in the paste option is included. For, example, I can paste-values, paste-formulas, but not regular paste or paste-formatting. If I clear the conditional formatting from the sheet, the problem still exists. However, if I clear the conditional formatting from the sheet, save the file and then reopen it, the pasting of the formats gets restored. A similar issue occurred a few windows updates ago and I rolled back the update for excel and/or applied the patch KB5002914. But this is a new issue and that patch doesn't work -- the message I receive is that "The update is already installed on this system". Is this happening to anyone else? Is there a solution to fix this behavior in excel with conditional formatting? Thanks!
