User Profile
NikolinoDE
Platinum Contributor
Joined Jul 08, 2020
User Widgets
Recent Discussions
Re: how do I add a Windows 11 onedrive shared folder on my Mac Finder Sidebar?
You cannot directly mount OneDrive as a network drive (SMB/WebDAV) on macOS anymore. Microsoft disabled that years ago. The only way to get a shared OneDrive folder into Finder is through the OneDrive for Mac app. To add a Windows 11 OneDrive shared folder to your Mac's Finder Sidebar without using a browser, follow these steps: Step 1: Install & Sign In to OneDrive for Mac Download OneDrive for macOS (not just Finder integration). Open the app and sign in with the Microsoft account that received the shared folder. Step 2: Add Shared Folder to "My Files" (One-Time Browser Action) Shared folders don’t sync automatically—you must explicitly add them. Requires a browser once (Safari/Chrome): Go to OneDrive Web → Shared. Find the folder shared from the Windows 11 user. Right-click the folder → "Add shortcut to My files" (or "Add to my files" for business accounts). Step 3: Sync the Folder to Your Mac The OneDrive app will now download the folder to: ~/OneDrive/[Shared Folder Name] (or under your company name for business accounts). Wait for sync to complete (check OneDrive app status). Step 4: Add to Finder Sidebar Open Finder. Navigate to the synced folder: Your Mac > OneDrive > [Shared Folder Name]. Drag the folder to Favorites in the sidebar. Or right-click the folder → "Add to Favorites". Result… Finder Sidebar: Folder appears under Favorites. Offline Access: Works offline if fully synced. Sync: Bi-directional sync via OneDrive (no browser needed after setup). Cross-Platform: Works seamlessly between Windows 11 and macOS. Common Fixes Folder Missing in OneDrive App? You skipped Step 2—shared folders aren’t synced by default. Repeat Step 2. Sync Stuck? Pause/resume OneDrive sync (right-click OneDrive icon → Pause Syncing→ resume). Key Notes No Network Drive Needed: Uses local sync, not SMB/WebDAV. Browser Only for Initial Setup: After adding to "My files", no browser is required. Business/Personal Accounts: Works for both Microsoft 365 and personal OneDrive. This method is confirmed by Microsoft and avoids deprecated network drive workarounds. My answers are voluntary and without guarantee! Hope this will help you. Was the answer useful? Mark as best response and like it! This will help all forum participants.0Views0likes0CommentsRe: Opening a Word document from an Excel spreadsheet
Below are two simple approaches, starting with the easiest and then a slightly more flexible one. Just want to open Word This method simply tells Excel to open the Word file, just as if you double-clicked it. Sub OpenWordDocument() Dim wordFilePath As String wordFilePath = "C:\YourFolder\YourDocument.docx" If Dir(wordFilePath) <> "" Then Workbooks.Open wordFilePath Else MsgBox "File not found." End If End Sub This works because Windows knows Word files must be opened by Microsoft Word. Want to edit or automate Word This method starts Word explicitly, opens the document, and gives you control over Word if you need it later. Enable Word reference (optional but helpful) In the VBA Editor, click Tools → References Check Microsoft Word xx.x Object Library Click OK This gives you IntelliSense and better error checking. Sub OpenWordDocument() Dim wdApp As Object Dim wdDoc As Object Dim wordFilePath As String wordFilePath = "C:\YourFolder\YourDocument.docx" ' Start Word Set wdApp = CreateObject("Word.Application") wdApp.Visible = True ' Open the document Set wdDoc = wdApp.Documents.Open(wordFilePath) End Sub My answers are voluntary and without guarantee! Hope this will help you. Was the answer useful? Mark as best response and like it! This will help all forum participants.3Views0likes0CommentsRe: Excel VBA – Target a specific named table when multiple ListObjects exist on each worksheet
You’re on the right track already. The key change is that instead of referencing the first table on the worksheet (ListObjects(1)), you should explicitly reference the table by its name, since you already have a predictable naming convention (LotSize01 … LotSize12). Using the month index, you can dynamically build the table name and safely target only the required table on each worksheet. Below is a clean and robust version of your procedure. Sub UpdateTables() Dim monthNames As Variant monthNames = Array("January", "February", "March", "April", "May", "June", _ "July", "August", "September", "October", "November", "December") Dim vals As Variant vals = Array("A", "B", "C", "D", "E") Dim ws As Worksheet Dim tbl As ListObject Dim lr As ListRow Dim i As Long, j As Long Dim tblName As String For i = LBound(monthNames) To UBound(monthNames) Set ws = ThisWorkbook.Worksheets(monthNames(i)) tblName = "LotSize" & Format(i + 1, "00") On Error Resume Next Set tbl = ws.ListObjects(tblName) On Error GoTo 0 If Not tbl Is Nothing Then With tbl ' Clear LotSize column If Not .ListColumns("LotSize").DataBodyRange Is Nothing Then .ListColumns("LotSize").DataBodyRange.ClearContents End If ' Ensure table has exactly 5 rows Do While .ListRows.Count > 0 .ListRows(1).Delete Loop ' Populate SCRIP column For j = LBound(vals) To UBound(vals) Set lr = .ListRows.Add lr.Range(.ListColumns("SCRIP").Index).Value = vals(j) Next j End With End If Set tbl = Nothing Set ws = Nothing Next i End Sub The earlier suggestion from m_tarler to use ListObjects("LotSize"&Format(i,"00")) is absolutely correct — this version simply shows how to integrate that idea cleanly into your existing loop while fully meeting both of your requirements. This approach should scale well even if additional tables are added later. My answers are voluntary and without guarantee! Hope this will help you.3Views0likes0CommentsRe: Hide rows based on Drop-down box selection
Could you please share: Your current VBA code (you can paste it as text) Details about your dropdown: Is it a Data Validation dropdown or an ActiveX/Form Control? Which cell contains the dropdown? What's the exact text of the selection options? Additional: Which operating system? Which Office version? In this link you will find some more information about it: Welcome to your Excel discussion space! So no one needs to guess and exclude many ways/causes with a lot of communicative time. Thank you for your understanding and patience NikolinoDE I know I don't know anything (Socrates)10Views0likes0CommentsRe: Excel VBA – Target a specific named table when multiple ListObjects exist on each worksheet
To modify the VBA code to target the specific named table LotSize?? (where ?? is the two-digit month number) on each worksheet, even when multiple tables exist, follow these steps: Key Changes: Dynamic Table Name Construction: For each month (e.g., January), construct the table name as LotSizeXX (e.g., LotSize01 for January). Direct Table Reference: Use ws.ListObjects("LotSizeXX") to directly access the target table instead of relying on the first table. Error Handling: Add On Error Resume Next to skip missing tables and avoid runtime errors. Modified Code: Sub UpdateTables() Dim monthNames As Variant monthNames = Array("January", "February", "March", "April", "May", "June", _ "July", "August", "September", "October", "November", "December") Dim vals As Variant vals = Array("A", "B", "C", "D", "E") Dim ws As Worksheet Dim tbl As ListObject Dim lr As ListRow Dim i As Long Dim j As Integer Dim monthNumber As Integer Dim targetTblName As String For i = LBound(monthNames) To UBound(monthNames) monthNumber = i + 1 ' January (index 0) → 01, February → 02, etc. targetTblName = "LotSize" & Format(monthNumber, "00") ' e.g., "LotSize01" Set ws = ThisWorkbook.Worksheets(monthNames(i)) ' Directly reference the target table by name On Error Resume Next ' Skip if table doesn't exist Set tbl = ws.ListObjects(targetTblName) On Error GoTo 0 ' Reset error handling If Not tbl Is Nothing Then With tbl ' Clear existing data in the table If Not .DataBodyRange Is Nothing Then .DataBodyRange.ClearContents ' Clears data but keeps structure End If ' Add 5 rows and populate SCRIP column For j = 1 To 5 Set lr = .ListRows.Add(AlwaysInsert:=True) lr.Range(.ListColumns("SCRIP").Index).Value = vals(j - 1) Next j End With Else Debug.Print "Table not found in sheet: " & ws.Name ' Optional: Log missing tables End If Set tbl = Nothing ' Release object reference Set ws = Nothing Next i End Sub The code handles 12 sheets automatically and can be extended by modifying monthNames. This solution ensures the code operates on the correct table (LotSizeXX) regardless of other tables on the sheet. My answers are voluntary and without guarantee! Hope this will help you. Was the answer useful? Mark as best response and like it! This will help all forum participants.1View0likes0CommentsRe: Excel VBA – Target a specific named table when multiple ListObjects exist on each worksheet
To modify the VBA code to target the specific named table LotSize?? (where ?? is the two-digit month number) on each worksheet, even when multiple tables exist, follow these steps: Key Changes: 1. Dynamic Table Name Construction: For each month (e.g., January), construct the table name as LotSizeXX (e.g., LotSize01 for January). 2. Direct Table Reference: Use ws.ListObjects("LotSizeXX") to directly access the target table instead of relying on the first table. 3. Error Handling: Add On Error Resume Next to skip missing tables and avoid runtime errors. Modified Code: Sub UpdateTables() Dim monthNames As Variant monthNames = Array("January", "February", "March", "April", "May", "June", _ "July", "August", "September", "October", "November", "December") Dim vals As Variant vals = Array("A", "B", "C", "D", "E") Dim ws As Worksheet Dim tbl As ListObject Dim lr As ListRow Dim i As Long Dim j As Integer Dim monthNumber As Integer Dim targetTblName As String For i = LBound(monthNames) To UBound(monthNames) monthNumber = i + 1 ' January (index 0) → 01, February → 02, etc. targetTblName = "LotSize" & Format(monthNumber, "00") ' e.g., "LotSize01" Set ws = ThisWorkbook.Worksheets(monthNames(i)) ' Directly reference the target table by name On Error Resume Next ' Skip if table doesn't exist Set tbl = ws.ListObjects(targetTblName) On Error GoTo 0 ' Reset error handling If Not tbl Is Nothing Then With tbl ' Clear existing data in the table If Not .DataBodyRange Is Nothing Then .DataBodyRange.ClearContents ' Clears data but keeps structure End If ' Add 5 rows and populate SCRIP column For j = 1 To 5 Set lr = .ListRows.Add(AlwaysInsert:=True) lr.Range(.ListColumns("SCRIP").Index).Value = vals(j - 1) Next j End With Else Debug.Print "Table not found in sheet: " & ws.Name ' Optional: Log missing tables End If Set tbl = Nothing ' Release object reference Set ws = Nothing Next i End Sub The code handles 12 sheets automatically and can be extended by modifying monthNames. This solution ensures the code operates on the correct table (LotSizeXX) regardless of other tables on the sheet. My answers are voluntary and without guarantee! Hope this will help you. Was the answer useful? Mark as best response and like it! This will help all forum participants.1View0likes0CommentsRe: MacOS 14.8.1 OneDrive - Timestamped Sync Root directory?
The issue you're encountering with two OneDrive Shared Libraries sync roots (one with a timestamp) on macOS is rare but can occur due to migration, sync conflicts, or backup processes. Steps maybe You can try… 1. Confirm only one OneDrive app is installed If you have both the App Store and standalone versions of OneDrive installed, remove one. That avoids confusion and duplicate syncing. 2. Check OneDrive sync status and account settings Open OneDrive’s menu > Preferences > Account to ensure only the correct shared libraries are syncing. This helps confirm which folder tree is the active sync root. 3. Use Files On‑Demand settings If you don’t need Always keep on this device for Shared Libraries, turn it off — this can reduce the amount of local data in both the CloudStorage and cache areas. 4. Verify actual disk usage Use Apple Menu → About This Mac → Storage to see how macOS reports OneDrive usage. This can sometimes show actual used space vs what folder size tools report. You should not manually delete or remove the timestamped folder or anything inside the OneDrive or Group Containers path. Update OneDrive: Ensure you’re on the latest version (macOS Store > Updates). Reset OneDrive Cache: Hold Option while clicking the OneDrive icon > Quit > Re-launch with Command key pressed > Reset. Check Shared Library Settings: In OneDrive settings > Account > Choose Folders, ensure only necessary libraries are synced. These are some things you could try without causing permanent damage. To be honest, I'm also at a loss as to what exactly might be causing the problem... Perhaps this will help you make some progress. My answers are voluntary and without guarantee!9Views1like0CommentsRe: How do I save an Excel Add-in (XLAM) file?
Excel changed the save dialog behavior slightly in newer versions, which can make it feel like you can’t save an add-in (XLAM) anymore. If your newer Excel version (Microsoft 365 or Excel 2021) no longer shows the .xlam option in the Save As dialog. What you can do… Use the "Save As" Dialog Correctly Even if the .xlam option is missing initially, you can force it: In the Save as type dropdown, scroll to the bottom and select: Excel Add-In (*.xlam). If not visible, type *.xlam manually in the "File name" field. Click Save. Enable "Excel Add-In" in the Save As Dialog Newer Excel versions may hide legacy formats by default. To restore visibility: In the Save As dialog, right-click the toolbar/header. Select All Files or Legacy Formats to reveal .xlam. Check Trust Center Settings Excel may block .xlam saves due to security policies: Go to File > Options > Trust Center > Trust Center Settings. Select File Block Settings. Ensure Excel Add-in Files is unchecked (not blocked). Click OK to save. Use VBA to Save the Add-In Programmatically If the UI fails, use this VBA macro to save your file as .xlam: Sub SaveAsAddIn() Dim filePath As String filePath = "C:\YourAddinFolder\YourAddinName.xlam" ThisWorkbook.SaveAs _ FileName:=filePath, _ FileFormat:=xlExcelAddIn, _ CreateBackup:=False MsgBox "Add-in saved successfully!", vbInformation End Sub Repair Office Installation If .xlam is entirely missing: Open Control Panel > Programs > Programs and Features. Right-click Microsoft Office > Change > Quick Repair. Restart Excel and retry saving. Check File Associations Ensure .xlam files are associated with Excel: Right-click any .xlam file > Open with > Choose another app. Select Excel and check Always use this app. My answers are voluntary and without guarantee! Hope this will help you. Was the answer useful? Mark as best response and like it! This will help all forum participants.3Views0likes1CommentRe: Formatting Issue
To resolve Excel freezing when clicking the Margins button in the Page Layout tab, follow these steps: Cause Easy Fix for Users Zoom / Display scaling Make sure your Excel zoom is set to 100% (bottom-right corner). Then try Page Layout → Margins again. Add-ins Start Excel normally, and if it still freezes, open Excel in Safe Mode (hold Ctrl while starting Excel). Then go to File → Options → Add-ins and turn off any extra add-ins. Corrupted Settings Sometimes Excel settings get messed up. If issues continue, IT can reset Excel settings for you. Printer Drivers Excel checks your default printer when opening Margins. Set your default printer to Microsoft XPS Writer or OneNote. File Corruption If this file still freezes, try saving it as a new file (.xlsb) or use Open and Repair in Excel. Graphics Drivers If nothing else works, go to File → Options → Advanced → Display and disable hardware graphics acceleration (IT can help if you’re unsure). After these steps, Excel should respond normally when adjusting margins. If the issue persists, it may indicate a deeper system conflict (e.g., Windows update, antivirus interference), then needed more information . My answers are voluntary and without guarantee! Hope this will help you. Was the answer useful? Mark as best response and like it! This will help all forum participants.2Views0likes0CommentsRe: Color palette and Color picker not working inside the conditional format
Please add more information. Which operating system? Which Office version? Where are the files stored? (OneDrive, Sharepoint, hard drive, USB, etc.). Attach some photos with the problem and explain your concern/problem step by step on the basis of these photos. Even better, insert one of these files (without sensitive data). So no one needs to guess and exclude many ways/causes with a lot of communicative time. In the end, however, without more information about your specific situation, it's difficult to say for sure that this will solve the problem. Try changing the steps as suggested and see if that fixes the problem. 1. Update Excel Microsoft 365: Go to File > Account > Update Options > Update Now. Excel 2019/2016: Check for updates via your account or the Microsoft Update Catalog. 2. Repair Office Installation Open Control Panel > Programs > Programs and Features. Right-click Microsoft Office > Change > Quick Repair (or Online Repair). 3. Disable Add-ins Start Excel in Safe Mode: Hold Ctrl while launching Excel. If the issue resolves, disable add-ins via File > Options > Add-ins > uncheck suspicious add-ins. 4. Adjust Display Scaling Right-click the Desktop > Display Settings. Set Scale and layout to 100% (temporarily). 5. Update Graphics Drivers Update your GPU driver via the manufacturer’s website (e.g., NVIDIA, Intel, AMD). 6. Manual Color Entry (Workaround) If the picker still fails: In the Conditional Formatting dialog, manually input RGB/HEX values: Click More Colors > Custom tab. Enter RGB values (e.g., 255, 0, 0 for red) or a HEX code (e.g., #FF0000). 7. Reset Excel Settings Close Excel. Press Win + R, type %appdata%\Microsoft\Excel, and delete the Excel16.xlb file (back up first!). 8. Reinstall Office Uninstall via Control Panel > Programs, then reinstall from office.com. My answers are voluntary and without guarantee! Hope this will help you.2Views0likes0CommentsRe: Help with a Formula
Great question — and sharp catch on the #CALC! 😊 Your test fails because MAP can't return arrays of different widths (3 cols, then 1 col, then 2 cols) — Excel needs a rectangular result. My formula works only if every cell in columns 49 & 53 splits into the same number of items (e.g., all split to 2 values → 2 columns). If splits vary, it also breaks with #CALC!. =MAP({"a,b,c";"d";"e,f"}, LAMBDA(x, TEXTSPLIT(x,","))) Tries to return {a,b,c} (3 cols), then {d} (1 col), then {e,f} (2 cols) → non-rectangular → #CALC!. My formula works...sometimes CHOOSECOLS(f,49) feeds MAP a single column. If every cell splits to the same number of pieces (e.g., always 2 values), Excel builds a clean 2-column spill → HSTACK accepts it. The MAP + TEXTSPLIT combo creates temporary arrays inside the formula that #CALC! on their own, but they work perfectly when fed into HSTACK() and UNIQUE(). You cracked the code by spotting the #CALC!—it's exactly why we need HSTACK as the next step. The individual pieces look broken, but together they create the final structure. Well spotted, and great debugging!👍 Thanks for sharing it with us🙂.14Views1like1CommentRe: OneDrive app stopped running on Mac
This is a known macOS container corruption issue and a clean reinstall almost always resolves it. The core issue is a corrupted local OneDrive configuration. A clean reinstall will resolve it. Steps to Fix: 1. Uninstall OneDrive Completely: Open Finder > Applications. Drag Microsoft OneDrive to the Trash. Empty the Trash. 2. Remove the Library Folder (Key Step): In Finder, press Cmd + Shift + G. Type ~/Library and press Go. Find and delete these two folders: ~/Library/Application Support/OneDrive ~/Library/Containers/com.microsoft.OneDrive-mac This clears the corrupted settings causing the error. 3. Fresh Install & Restart: Download the latest OneDrive for Mac directly from onedrive.com/download. Open the downloaded OneDrive.pkg and follow the installer. Restart your Mac (important for clean initialization). 4. Set Up OneDrive: After restart, open OneDrive from your Applications folder. Sign in with your Microsoft 365 account. During setup, it will recreate the necessary folder. Choose its location carefully. You should now be back in sync. This process preserves all your cloud files; you're just re-establishing the local sync connection. If the issue persists, please check for any system updates in System Preferences > Software Update and ensure you have sufficient disk space. My answers are voluntary and without guarantee! Hope this will help you. Was the answer useful? Mark as best response and like it! This will help all forum participants.3Views0likes0CommentsRe: Metadata for .mov files radically different to originals
If you want your files on the PC to display the correct date in the main Explorer view (so you can sort them correctly), you need a tool to copy the internal "Media Created" date to the File System "Date Created". Use metadata-aware tools, not Explorer. You need a tool that reads embedded video metadata, not file system dates. The industry standard tool for this is ExifTool. It is a command-line tool, but it is the only reliable way to batch fix this on Windows. Or V L C Media Player, This often shows the correct timestamp even when Explorer doesn’t. Before deleting videos from your phone: Verify using embedded metadata, not file dates Prefer: ExifTool VL C 3. Do not rely on: Date Created Date Modified File name order My answers are voluntary and without guarantee! Hope this will help you.11Views1like0CommentsRe: Help with a Formula
=LET( f, FILTER(Detail!$A:$BZ, (COUNTIF($B$16:$B$25, Detail!$BP:$BP) > 0) * (TRIM(SUBSTITUTE(Detail!$AW:$AW, CHAR(160), "")) <> "")), base, CHOOSECOLS(f, 1, 3, 4, 5, 68), split49, MAP(CHOOSECOLS(f, 49), LAMBDA(x, LET( cleaned, TRIM(SUBSTITUTE(x, CHAR(160), "")), IF(cleaned = "", {""}, TEXTSPLIT(cleaned, ",")) ))), split53, MAP(CHOOSECOLS(f, 53), LAMBDA(x, LET( cleaned, TRIM(SUBSTITUTE(x, CHAR(160), "")), IF(cleaned = "", {""}, TEXTSPLIT(cleaned, ",")) ))), SORT(UNIQUE(HSTACK(base, split49, split53)), 1, TRUE) ) My answers are voluntary and without guarantee! Hope this will help you.20Views0likes3CommentsRe: is it possible to capture HH:MM from the cell in text format DD-MM-YYYY HH:MM
Calculating time durations that cross midnight can be tricky because Excel interprets "02:30" as a smaller number than "22:30", resulting in a negative value which Excel cannot display as time. Extract the time (HH:MM) from a text string formatted as "DD-MM-YYYY HH:MM" and calculate the duration between two times that may span midnight. Assumption OT Start (text): DD-MM-YYYY HH:MM in A1 OT End (text): DD-MM-YYYY HH:MM in B1 =MOD(TIMEVALUE(MID(B1,12,5)) - TIMEVALUE(MID(A1,12,5)),1) * 24 Result is 4. Explanation… MID(cell,12,5) → extracts HH:MM TIMEVALUE() → converts text to real Excel time MOD(...,1) → handles midnight rollover automatically *24 → converts time fraction to hours If I may recommend... Avoid keeping dates and times as text wherever possible. Convert them to real date/time values first, then format for display. This prevents calculation errors, especially when working across days. My answers are voluntary and without guarantee! Hope this will help you.4Views0likes0CommentsRe: Merging FROM and TO dates to 1 cell
…two methods: Universal Method (Works in all Excel versions, including Excel for Mac). Modern Method (Requires Excel 2019/365/2021, leveraging dynamic arrays). Method 1: Universal Formula (All Excel Versions) =TEXT(FROM_DATE_CELL, "dd-mm-yyyy") & " TO " & TEXT(TO_DATE_CELL, "dd-mm-yyyy") Steps: Replace FROM_DATE_CELL and TO_DATE_CELL with your actual cell references (e.g., A2 and A3). The TEXT function formats dates as dd-mm-yyyy. The & operator concatenates the formatted dates with " TO ". Example: If dates are in A2 (FROM) and A3 (TO): =TEXT(A2, "dd-mm-yyyy") & " TO " & TEXT(A3, "dd-mm-yyyy") Method 2: Modern Formula (Excel 2019/365/2021) =TEXTJOIN(" TO ",, TEXT(FROM_DATE_RANGE, "dd-mm-yyyy"), TEXT(TO_DATE_RANGE, "dd-mm-yyyy")) Steps: Replace FROM_DATE_RANGE and TO_DATE_RANGE with your date ranges (e.g., A2:A3 if dates are stacked vertically). TEXTJOIN combines the formatted dates with " TO " as the delimiter. Example: If dates are in A2 (FROM) and A3 (TO): =TEXTJOIN(" TO ",, TEXT(A2, "dd-mm-yyyy"), TEXT(A3, "dd-mm-yyyy")) …Considerations Regional Settings: The format "dd-mm-yyyy" assumes European date formatting. If your system uses "mm-dd-yyyy" (e.g., US), adjust to "dd-mmm-yyyy" (e.g., "01-Jan-2026") for clarity: =TEXT(A2, "dd-mmm-yyyy") & " TO " & TEXT(A3, "dd-mmm-yyyy") Date Locations: If dates are in the same row (e.g., A2 and B2), use: =TEXT(A2, "dd-mm-yyyy") & " TO " & TEXT(B2, "dd-mm-yyyy") Handling Time Components: If dates include time (e.g., 01-01-2026 15:30), use "dd-mm-yyyy hh:mm" to retain time: =TEXT(A2, "dd-mm-yyyy hh:mm") & " TO " & TEXT(A3, "dd-mm-yyyy hh:mm") Final Formula (Recommended) =TEXT(FROM_CELL, "dd-mm-yyyy") & " TO " & TEXT(TO_CELL, "dd-mm-yyyy") Troubleshooting #NAME? Error: Ensure TEXTJOIN is available (Excel 2019+). If not, use Method 1. Incorrect Format: Verify the date format code matches your regional settings (e.g., "mm/dd/yyyy" in the US). My answers are voluntary and without guarantee! Hope this will help you.1View0likes0CommentsRe: Not able to count with COUNTIFS
The reason your formula is returning 0 is likely due to data type mismatches or language/region settings, rather than a syntax error. When you use the TEXT function to convert a date to a word (e.g., "October"), Excel creates a specific text string. However, the TEXT function is highly sensitive to your Mac's Region and Language settings. Solution 1 Assuming your original Date column is named Date: Referral Rx, use this formula: =COUNTIFS( Table[Date: Referral Rx], ">=" & EOMONTH(TODAY(), -1) + 1, Table[Date: Referral Rx], "<=" & EOMONTH(TODAY(), 0)) Solution 2: Fix for your Current Formula for the most reliable result, as it avoids language and formatting issues entirely. If you must use text =LET( currentMonth, TRIM(TEXT(TODAY(), "[$-en-US]mmmm")), COUNTIFS(Table[Month: Initial Referral Rx],currentMonth)) Solution 3: Direct Date Comparison Count dates falling in the current month without converting to text: =COUNTIFS( Table[Date: Referral Rx], ">="&DATE(YEAR(TODAY()), MONTH(TODAY()), 1), Table[Date: Referral Rx], "<="&EOMONTH(TODAY(), 0)) …recommendation Do NOT store month names as text Instead, count by dates, which are reliable. My answers are voluntary and without guarantee! Hope this will help you.2Views0likes0CommentsRe: Recently saved local file not available
Here's a possible solution that might help you... Quickest Fix for Your Current File: Go online Find the file in OneDrive folder in File Explorer Right-click it → Always keep on this device Make a separate backup copy outside OneDrive immediately This is indeed a valid reason to reconsider OneDrive for critical files. Many businesses use alternatives like local network drives with proper backups or enterprise sync tools (Dropbox Business, Box) that offer more reliable offline access. If don’t heps… Clearing the OneDrive cache might help. Sometimes corrupted cache files cause sync issues. The user can reset OneDrive by pressing Win+R, typing %localappdata%\Microsoft\OneDrive, and deleting the contents (after closing OneDrive). Then restarting OneDrive might rebuild the cache. Workarounds for Next Time: Use "Save As" Instead of Save: When offline, use File → Save As Choose This PC → Documents (not OneDrive) Move to OneDrive later My answers are voluntary and without guarantee! Hope this will help you. Was the answer useful? Mark as best response and like it! This will help all forum participants.9Views0likes0CommentsRe: #NUM! ERRORS
When #NUM! errors “randomly” appear but disappear as soon as you re-enter the formula, it’s usually not a bad formula—it’s a calculation or precision issue. You can try to fix the issue with this steps… Step 1: Save the file. Step 2: Press Ctrl+Alt+Shift+F9 to force a full recalculation. Step 3: If the error persists, check for circular references. Step 4: If there are circular references, either fix them or enable iterative calculation (but be cautious because iterative calculation can lead to incorrect results if not used properly). Step 5: If no circular references, try to isolate the problem by removing sheets or parts of the data. If the problem is fixed by the full recalculation, then it might have been a corrupted dependency tree. If it happens again, then we might need to look deeper. However, note that the file is 1,017 KB (about 1MB). That's not extremely large, but it's moderate. It might have a lot of formulas. Another idea: the file might be using linked cells or external references that are sometimes unavailable? But that usually gives a #REF! error. Alternatively, the problem might be with the Excel installation? Try repairing Office. Steps: Go to Control Panel -> Programs -> Programs and Features -> Microsoft Office -> Change -> Repair. But that is a last resort. My answers are voluntary and without guarantee! Hope this will help you. Was the answer useful? Mark as best response and like it! This will help all forum participants.8Views0likes0CommentsRe: Excel pads dynamic array output with #NV values
=LAMBDA(assemblyName; LET( filteredParams; {"a";"b";"c"}; mappedValues; {1;2;3}; stacked; HSTAPELN(filteredParams; mappedValues); // 3x2 array transposed; MTRANS(stacked); // 2x3 array return; WENN(transposed = ""; "NV"; transposed); // Dimensions match (2x3) return ))("fake") for eliminating the #NV padding. Hope it helps 🙂34Views1like0Comments
Recent Blog Articles
No content to show