User Profile
NikolinoDE
Platinum Contributor
Joined Jul 08, 2020
User Widgets
Recent Discussions
Re: Formula Help
Based on your latest update, you've confirmed that the sheets (41 through 46) do exist, which eliminates the most common culprit. The fact that data flows to those sheets but doesn't come back is a critical clue. This strongly points away from a simple typo and toward a scope issue with the named range Rate. What probably happened… You set up Sheet '40' and defined "Rate" (e.g., in cell '40'!$B$5) using the Name Manager. When you created sheets '41' through '46' (likely by copying Sheet '40' or creating them manually), the Name Manager did not automatically create a "Rate" name for those specific sheets. Even though the sheet is named '41', Excel looks for a Named Range called "Rate" scoped specifically to that sheet, doesn't find it, and throws the #NAME? error. It does not automatically borrow the "Rate" from sheet '40'. Check…. The "Name Manager" Audit This is the cleanest way to fix the workbook so you don't have to rewrite formulas. Go to the Formulas tab on the ribbon and click Name Manager. In the list, look for the name Rate. Look at the Refers To column. Does it say =Sheet40!$B$5 (or similar)? The Fix... If you have many sheets, change the Scope of "Rate" to Workbook. OR, if the "Rate" cell is in a different location on every sheet (e.g., always cell B5), you might be better off deleting the Named Range entirely and using direct cell references (see Solution 3). OR, if you must keep the Named Range, you need to ensure every single sheet (40, 41, 42...) has its own "Rate" name defined in the manager. Note: If you copied the sheets, the new "Rate" names might be pointing back to Sheet 40's cells. You must edit them to point to their own sheet. Or use… The "Brute Force" Reference Named Ranges are great for readability, but terrible for copying sheets if not managed perfectly. The most "bulletproof" method in construction estimating is to stop using Named Ranges for single cells and just point to the cell directly. Go to sheet '41'. Find the cell that contains the rate (let's assume it is cell C5). Change the formula in your WBS sheet (G66) to: =IF(D66>0, '41'!$C$5 + $G$18, 0) If you have many sheets, this is tedious, but it eliminates the #NAME? error because Excel never has to "guess" what "Rate" means; you are giving it the exact GPS coordinates.0Views0likes0CommentsRe: Functions and formulars
Place this formula in cell B13: =IFS(B14>=30, "Pink", B14>=17, "Purple", B14<9, "Yellow", TRUE, "") If you are using a version of Excel before 2019, you might not have the IFS function. In that case, you "nest" IF functions inside each other. The logic is identical, but the syntax is a bit messier. =IF(B14>=30, "Pink", IF(B14>=17, "Purple", IF(B14<9, "Yellow", ""))) The VLOOKUP Method (Most Scalable) This is a more advanced but very powerful method, especially if you have many ranges (e.g., 10+ colors). It keeps your logic separate from your formula, making it very easy to update. =VLOOKUP(B14, D:E, 2, TRUE) All formulas in cell B13. I recommend the IFS function. It's the modern, clean, and correct way to solve this, my own opinion 🙂19Views0likes0CommentsRe: Excel array question - spill VOWD based on forecast month
=MAKEARRAY(ROWS(A2:A7), 1, LAMBDA(r,c, LET( fore_month, INDEX(A2:A7, r), SUMPRODUCT(N(COLUMN(B1:M1)<=COLUMN(B1)+fore_month-1), INDEX(B2:M7, r, 0))))) Based on your description, the logic is to sum the values from the first N months (where N equals the "Fore Month" value) for each pair of rows.35Views0likes0CommentsRe: Sensitive titled word doc now appears in company's onedrive and won't delete!
The "Remove" Trick Sometimes the "Delete" button is greyed out, but "Remove" still works. "Remove" unlinks the file from the folder but leaves it in the recycle bin (which you will empty next). Log into the Web Version of OneDrive (do not use the desktop app or File Explorer). Go to the file. Right-click the file. Look for Remove (it looks like a trash can with a minus sign or a broken link). Do not click Delete. If that works, go immediately to the Recycle Bin on the left sidebar and empty it. I hope this helps you17Views0likes0CommentsRe: onedrive.cync.service.exe disable how?
Quick Method Press Ctrl + Shift + Esc to open Task Manager Find onedrive.cync.service.exe in the list Right-click it and select "End task" This stops it right now, but we need to prevent it from coming back Permanent Remove the Service Since the app isn't showing up normally, let's remove the service entirely: Press Windows Key + R, type cmd, and press Ctrl + Shift + Enter (this runs Command Prompt as Administrator) If prompted by User Account Control, click "Yes" In the black window, type this command and press Enter: sc stop "onedrive.cync.service" 4. Then type this command and press Enter: sc delete "onedrive.cync.service" This directly removes the service so it can't run again. I hope this helps you9Views2likes0CommentsRe: Formula Help
A few questions before I get to my proposed solution. Have you actually created a sheet named '41' in your workbook yet? What is the exact name of the sheet tab that contains the data for item 41? (For example, is it just '41', or is it something like '41 - Kitchen' or 'Sheet41'?) Could there be a typo in the sheet name reference? For instance, is there an extra space in the sheet name (like '41 ' with a space after) or in your formula? Additional information such as operating system (Win ver., mac, etc.), storage medium (OneDrive, Sharepoint, Hard disk, etc.), Excel version, would be helpful in order to get an accurate solution. My suggestion corresponds to the information you provided in your message. First:..Rename the sheet OR Copy sheet "40" to create sheet "41" Fix the formula to match the actual sheet name If the sheet is named something like "41 - Bathroom", change your formula to: =IF(D66>0,'41 - Bathroom'!Rate+$G$18,0) Use INDIRECT for more flexibility If you want formulas that automatically adjust, you could use: =IF(D66>0,INDIRECT("'"&ROW(A41)&"'!Rate")+$G$18,0) But this is more complex and might not be necessary for your needs. Try checking if sheet "41" exists first - that's almost certainly the issue! I hope this helps you with your project.13Views0likes0CommentsRe: Time sheet for hours worked
Here's a small attempt, maybe this will help you. That calculates total hours worked with 6-minute increments (rounded to the nearest tenth of an hour). =FLOOR(( (Clock_Out - Clock_In) - (Lunch_Out - Lunch_In) ) * 24, 0.1) Example Breakdown: Clock_In: 8:00 AM (0.3333 in Excel) Lunch_Out: 12:00 PM (0.5) Lunch_In: 1:21 PM (0.55625) Clock_Out: 5:00 PM (0.70833) Calculation: =FLOOR(( (0.70833 - 0.3333) - (0.55625 - 0.5) ) * 24, 0.1) =FLOOR(7.65, 0.1) = 7.6 Ensure cells are formatted as [h]:mm to display time correctly.18Views1like1CommentRe: Time Zone
As an admin and developer, you've hit upon a common and often confusing issue in Microsoft Bookings. The problem where a booking page set to Central Time (CT) reverts to Eastern Time (ET) stems from the fact that Microsoft Bookings has two separate and independent time zone settings. One setting controls what your customers see (the booking page), and the other controls what you and your staff see (the booking calendar), which is tied to your personal Outlook on the Web (OWA) settings. When these are out of sync, it creates the exact issue you're describing. Ensure your Central Time booking page remains in Central Time for customers, while managing the staff calendar view correctly. Step 1: Set the Booking Page to Central Time (The Customer View) This is the most critical step to ensure your customers see the correct time. Go to Microsoft Bookings in your Microsoft 365 app launcher. In the left navigation pane, select Booking page. Select the specific booking page that is set to Central Time. Click on Change language and time zone settings. Under Time zone, explicitly select (UTC-06:00) Central Time (US & Canada). Crucially, check the box for "Always show time slots in business time zone". What this does: It forces the booking page to display times only in the time zone you just selected (Central Time), regardless of the customer's or your own computer's time zone. This is the key to preventing it from "reverting." Click OK and then Save and publish your booking page. Step 2: Align Your Outlook on the Web Settings (The Staff Calendar View) This step fixes the calendar view for you and your staff. If you want your Bookings calendar to also reflect Central Time, you must change your personal account setting. Log in to Outlook on the Web (outlook.office.com). Click the Settings (gear icon) in the top-right corner. Go to Mail > Calendar. Under the General tab, find the Time zone section. From the dropdown menu, select (UTC-06:00) Central Time (US & Canada). Click Save. Note: Outlook on the web will restart to apply the changes. After this, your Bookings calendar should display appointments in Central Time. Important Caveat: If your organization's IT administrator has locked this setting, you may not be able to change it. In that case, you must use the workaround in Step 3. Step 3: The Workaround for Locked Accounts (Use a Dedicated Staff Account) If you cannot change your primary account's time zone because of admin restrictions, the best practice is to use a dedicated "resource" or "staff" account for the Central Time booking page. Create a new user account in your Microsoft 365 admin center (e.g., "Central-Booking-Staff"). During setup, or by editing the user's profile, set its Time Zone to (UTC-06:00) Central Time (US & Canada). You may need to go into the user's Outlook on the Web settings to confirm this. In the Bookings app, go to the Staff tab. Add this new "Central-Booking-Staff" account as a staff member for the Central Time booking page. Ensure this new staff account is the one primarily associated with the schedule, not your personal account. Now, the booking page's calendar will use the new account's Central Time setting, while your personal account's Eastern Time setting remains untouched. The steps were created by and with AI; I was too lazy to list them step by step myself. Hope this helps you 🙂0Views0likes0CommentsRe: Organizational Account authentication problem
This is a known, frustrating issue that typically arises from a token caching mismatch or a broken authentication state within the Excel/Office identity broker. Since it works in Power BI Desktop but fails in Excel (and specifically the "Sign in as different user" button behaves erratically), the issue is almost certainly local to the Excel client's handling of ADFS/WS-Fed modern authentication. Clear the Office Credential Cache (Most Likely Fix) The symptom where the "Sign in as different user" button opens and closes immediately suggests Excel has a corrupted or stale cached token for ce.xxx.com. It tries to use the token, fails, but the UI logic to request a new one is broken. Close Excel completely. Open Control Panel > User Accounts > Credential Manager (or search "Manage Windows Credentials"). Go to the Windows Credentials tab. Look for any credentials related to ce.xxx.com, Dynamics365, or MicrosoftOffice16_Data:adalsso. Remove all of them. Advanced Step: If the above doesn't work, you may need to clear the ADAL cache files. Close Excel, then delete the contents of: %localappdata%\Microsoft\Identity\ADAL (Note: This will force a re-login for all Office apps). Restart Excel and try the connection again. Force WebView2 Repair Repair WebView2 runtime: Go to Apps & Features Find Microsoft Edge WebView2 Runtime Repair Or reinstall it. If your organization recently updated security policies, Excel might have fallen back to legacy auth. You can force it to use the modern ADAL/OWA stack via the registry. Open regedit. Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\Identity. Create a DWORD (32-bit) Value named EnableADAL. Set the value to 1 (or 2 for "Force ADAL"). Also, check HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\Identity\DisableADALatopWAMOverride and ensure it is set to 1 (to prevent the Web Account Manager from interfering with ADFS). Restart Excel. 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: Macro Dummy
Based on the analysis of your VBA macro code, here's a breakdown of the key issues and how to fix them. Your code searches row 1 but says "Row 27" in the comment for data extraction, Make sure your row references are correct. Your code was searching for "letter L" instead of "row 1" due to lowercase "l". Anyway, here's my attempt at a solution... Sub GetDataByDate() Dim wsReport As Worksheet Dim wsSchedule As Worksheet Dim targetDate As Date Dim foundRange As Range ' Safety: Check worksheets exist On Error Resume Next Set wsReport = ThisWorkbook.Sheets("Report") Set wsSchedule = ThisWorkbook.Sheets("Work Schedule") On Error GoTo 0 If wsReport Is Nothing Or wsSchedule Is Nothing Then MsgBox "Required worksheet missing!", vbCritical Exit Sub End If ' Validate date input If Not IsDate(wsReport.Range("B1").Value) Then MsgBox "Invalid date in Report!B1", vbExclamation Exit Sub End If targetDate = CDate(wsReport.Range("B1").Value) ' Search row 1 (fixed typo) Set foundRange = wsSchedule.Rows(1).Find(targetDate, LookIn:=xlValues) If foundRange Is Nothing Then MsgBox "Date not found in schedule header", vbExclamation Else ' Dynamic row reference (replace hardcoded 27) Dim dataRow As Long dataRow = 27 '← Change this number if needed wsReport.Range("B5").Value = wsSchedule.Cells(dataRow, foundRange.Column).Value MsgBox "Data copied successfully!", vbInformation End If End Sub Added Keys… 1. Flexible Date Handling Added CDate() to standardize date formats during comparison 2. Error Prevention Checks worksheet existence before proceeding Validates date input before search Clear error messages for troubleshooting 3. Maintainability Centralized dataRow variable (change once, update everywhere) Clear comments explaining each step Your Actions… Replace dataRow = 27 with your actual target row number Test with Ctrl+Break to enter debug mode and step through Add Application.ScreenUpdating = False at start and True at end for faster execution My answers are voluntary and without guarantee! Hope this will help you.0Views0likes0CommentsRe: Excel auto-truncating timestamps sub milliseconds
You're right that Excel truncates sub-millisecond data (microseconds and nanoseconds) because its datetime format only supports precision down to milliseconds .You’re running into a precision limitation in Excel, not just a formatting issue. The stair-step graphs are the telltale sign of lost precision. Practical Workaround Instead of double-clicking the CSV (which forces Excel's auto-formatting), set up a proper import that preserves your full timestamps with Power Query Import. Open a blank Excel workbook (don't double-click the CSV) Go to the Data tab → Get Data → From File → From Text/CSV Select your CSV file and click Import CRITICAL STEP: In the preview window, find your timestamp column Click the data type icon (usually says "ABC" or "Date") next to the column header Change it from whatever it auto-detected to "Text" Click Load This brings all your data in exactly as written in the CSV—no truncation, no auto-formatting. Your timestamps like 2025-12-18 00:08:46.730845 will remain intact as text strings. Considerations… If you later convert the text to a datetime format in Excel, it may still truncate sub-milliseconds. Excel's native datetime format only supports up to milliseconds (3 decimal places). Workaround: Keep timestamps as text for storage, and use Python/pandas for analysis where pd.to_datetime() preserves nanoseconds. Use Power Query for storage (import as text) and Python for analysis/visualization. This hybrid approach gives you: Data Integrity: Timestamps remain intact in Excel. Flexibility: Leverage pandas for high-precision calculations/plotting. My answers are voluntary and without guarantee! Hope this will help you.9Views0likes0CommentsRe: Need 1 worksheet to add totals from multiple worksheets in the same file.
I’ve seen proposals for using '*'!A1:A100 to sum across sheets—great creativity! While wildcards are convenient here, they are risky. It is better, and above all safer, to use =SUM(Sheet1:Sheet3!A1) or explicit references to ensure reliability! Excel deliberately restricts worksheet references in formulas to explicit names or contiguous ranges to ensure clarity, security, and performance. The wildcard character * is not supported, as it would lead to ambiguities and risks that contradict Excel's design principles. Microsoft doesn’t explicitly state, "We restrict wildcards in sheet references to avoid ambiguity," but their documentations implies it throughFor dynamic or non-contiguous sums, VBA or structured, defined names are, in my opinion, the most reliable solutions. Wildcards (* and ?) in Excel are safe and powerful when used in specific functions designed for pattern matching. Like Check if a cell contains a substring. Example in SEARCH/FIND for partial text matches =IF(ISNUMBER(SEARCH("*apple*", A2)), "Found", "Not Found") // Case-insensitive =IF(ISNUMBER(FIND("*apple*", A2)), "Found", "Not Found") // Case-sensitive Nevertheless, it's a nice approach, thank you for sharing🙂.14Views0likes1CommentRe: Revenue structure
If your original formula was: =IF(F6="", 0, B6 + (C6 * D6)) Modify it to: =IF(OR(E6="", F6=""), B6, B6 + (C6 * D6)) emanate: Base Fee is in cell B6 Increment Date is in cell E6 Termination Date is in cell F6 Original calculation (when dates exist) is: (Base Fee + (Increment Amount * Months))20Views0likes0CommentsRe: Revenue structure
Based on the screenshot you provided, I can see the exact column layout. The previous formula I gave might have been based on a different column assumption. Here is the corrected, robust solution tailored specifically to the column layout in your screenshot (Columns B through F). Place this formula in cell G3 (which corresponds to Jan 26 for Client A) and drag it right and down. =IF(G$2 < $B3, 0, IF(G$2 >= $F3, 0, IF(G$2 >= $D3, $E3, $C3))) *If your Excel uses semicolons instead of commas, use: =IF(G$2 < $B3; 0; IF(G$2 >= $F3; 0; IF(G$2 >= $D3; $E3; $C3)))). If you says "It's not working," , please check these 3 things: Date Formats: Ensure Row 2 (Jan 26, Feb 26) are actual Dates and not just text. If they are text, the comparison G$2 >= $B3 will fail. Absolute References: Ensure they copied the formula exactly, especially the $ signs. If they drag the formula and the references shift (e.g., B3 becomes C3), the logic breaks. Termination Logic: The formula assumes that if the Termination Date is, for example, 14/11/2026, the revenue for November is 0. If they want revenue for the month of termination, change G$2 >= $F3 to G$2 > $F3. However, standard accounting usually cuts off revenue on the termination date, so >= is safer. "I have adjusted the formula based on the screenshot you sent. The columns are slightly different than the generic description. Please use this specific formula in cell G3 (Jan 26 for Client A) and drag it across and down: =IF(G$2 < $B3, 0, IF(G$2 >= $F3, 0, IF(G$2 >= $D3, $E3, $C3))) This handles the automatic zeroing of future months and the fee escalation without needing to change the formula for next year. My answers are voluntary and without guarantee! Hope this will help you.4Views0likes0CommentsRe: Link doesn't work
The error message shows Excel trying to open a file:/// link to a UNC path with URL-encoded spaces: file:///\\G...\Year%20end%20pack%202024.xlsx%23API!A1 This is almost always a link parsing issue, not a missing file. This strongly suggests a profile-specific Office/URL handler issue, not a global Excel or server problem. Most Likely Cause Excel 365 (newer builds like 2601) sometimes mishandles: URL-encoded file paths file:/// UNC format links FSLogix-mounted profile redirections Especially when the hyperlink includes a cell reference (#API!A1). Workarounds/Fix Recreate the Hyperlink From: file:///\\Server\Share\Folder\Year%20end%20pack%202024.xlsx#API!A1 to: \\Server\Share\Folder\Year end pack 2024.xlsx#API!A1 Or recreate using: Right-click → Link → Existing File → browse to file Do NOT paste a file:/// URL. If this fixes it → your issue is URL encoding handling in that build. If You Want a Permanent Technical Solution If these are auto-generated links (SharePoint, scripts, etc.), modify them so they: Don’t use: file:///\\server\share\file.xlsx Use: \\server\share\file.xlsx In the End, in AVD environments on 2601, the most consistent fix I've seen is: Online Repair Office + disable Office file sync integration. 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: Revenue structure
The challenge is to make these formulas dynamic so that when a termination date or fee change is entered, all future months automatically update without manual intervention. Also, the solution should work in both Excel and Google Sheets. I think using a combination of IF statements and date comparisons would work. For termination, the formula in each month's revenue cell would check if the termination date is before or equal to the month in the column header. If yes, return zero; else, use the previous month's revenue (or the original value if it's the first month). I think the solution involves setting up a table with client names, termination dates, fee change dates, and then using formulas that reference these dates to determine the revenue for each month. To implement the termination and fee update logics in Excel/Google Sheets with automatic future-month adjustments, you can follow this structured approach: Formula for Monthly Revenue (e.g., Cell B3 for Client A, Jan 2026): =IF(B$2 >= $C3, 0, IF(ROW(B3)=ROW($B$3), $D3, IF(B2=0, 0, B2))) Annual Total (e.g., Cell N3): =SUM(B3:M3) Fee Update Logic Implementation Setup Fee Schedule Table (e.g., Columns O:R): Client Fee Change Date New Fee Exact Match Flag A 2026-07-01 1500 TRUE Formula for Monthly Fee (e.g., Cell D3 for Client A): =IFERROR( XLOOKUP(B$2, $O:$O, $R:$R, $D$2, 0, 1), $D$2) Replace XLOOKUP if in Google Sheets is unavailable. =IFERROR(VLOOKUP(B$2, $O:$R, 4, 1), $D$2) Date Formatting: Ensure termination dates (Column C) and fee change dates (Column O) are stored as YYYY-MM-DD (e.g., 2026-07-01) for reliable comparisons. Fee Schedule Sorting: If using VLOOKUP, sort the fee schedule table by date in ascending order. XLOOKUP doesn’t require sorting. Total Column: Use =SUM(B3:M3)—it will dynamically exclude zeroed months post-termination. I Think this approach is scalable, maintainable, and error-resistant. Test it with a small dataset first to confirm behavior, then scale to your full dataset. For Google Sheets, prioritize XLOOKUP or exact-match VLOOKUP to avoid lookup errors. 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.0Views0likes2CommentsRe: Excel hänger sig
Om Excel på en iPad "fryser" i en miljö som ett EU-kontor beror det vanligtvis på en kombination av nätverksinstabilitet, molnsynkronisering och iPadens begränsade RAM-minne jämfört med en PC. Även om iPad-versionen av Excel är imponerande är den inte lika kraftfull som Excel för Windows/Mac. Om filen innehåller stora pivottabeller, Power Query, många bilder eller komplexa makron (VBA körs inte alls på iPaden, men kan orsaka fel när filen synkroniseras) kan iPadens RAM-minne bli förbrukat. När minnet är fullt stänger iOS bakgrundsappar. Om Excel använder mest minne vid den tidpunkten kommer det att krascha eller frysa. VPN och säkerhetspolicyer (särskilt för EU-kontor): Extremt strikta säkerhetsprotokoll finns i EU-miljöer. Att använda en VPN-klient (t.ex. Cisco AnyConnect, Zscaler) i bakgrunden för att komma åt interna dokument kan leda till konflikter. VPN:et krypterar datatrafiken, vilket gör att Excels statusmeddelanden till Microsofts servrar antingen misslyckas eller tar för lång tid. Detta leder oundvikligen till att appen kraschar. Inaktivera VPN helt om filen finns i molnet. Om filen finns lokalt på iPaden är det ofta onödigt att ha ett aktivt VPN som körs i bakgrunden under redigeringen. Det finns många potentiella felkällor i en så känslig och ständigt föränderlig miljö som ett EU-kontor; jag har bara nämnt några. Det kan också vara appens cache, eftersom man ofta måste starta om iPaden. Eller så kan det vara iOS-lagringshantering; men utan att kunna undersöka det kan vi bara spekulera. Kanske kan dessa förslag hjälpa dig. 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.8Views0likes1CommentRe: How can I zoom in and zoom out in Design View?
In Microsoft Access, when you’re working in Design View (for a form or report), you can zoom in and out in a couple of ways, depending on what you want to enlarge—text, controls, or the overall design. If you’re trying to read small text in a property box, use Shift+F2 for a pop-up zoom editor. Table/Query Design View doesn’t have a zoom slider—only Form/Report Design does. For tables/queries, adjust column widths manually or use Window controls (like resizing the window). Tip: If nothing above works, check your Access version (steps vary slightly for 2016, 2019, 365, etc.). The status bar zoom slider is the quickest method for forms/reports. 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.15Views0likes0CommentsRe: Unircadenas => Delimitador
Enfoque alternative… Para Excel 365 (versiones más recientes), Excel para la Web. =UNIRCADENAS(UNICAR(8232); VERDADERO; A1:B20) Para máxima compatibilidad con versiones anteriores, utilice: =UNIRCADENAS(UNICAR(10) & UNICAR(13); VERDADERO; A1:B20) Estas fórmulas son compatibles con Unicode. Funcionan de forma uniforme en todas las plataformas. Ofrecen mayor compatibilidad con aplicaciones web y móviles. Nota: Active siempre el ajuste de texto en la celda de resultado. ¡Mis respuestas son voluntarias y sin garantía! Espero que esto te ayude.18Views0likes0CommentsRe: No stocks button/option
The 3 Most Likely Causes… You’re signed in with the wrong Microsoft account Your Microsoft account country/region is unsupported You’re using a Work/Business tenant with data types disabled What you can do for Right Now: First, check About Excel. Confirm the correct account is active in the app. Immediately, check your Microsoft Account's Country/Region at the link above. This is the fastest, most common fix for personal accounts. Finally, check portal.office.com for any signs of a work/school tenant. Most Likely Order of Probability for Your Case: Given the issue is on both Mac and Web, and you have an Apple ID subscription, I'd rank them: #2 - Unsupported Country/Region (Most common for personal accounts with global mobility) #3 - Work/Business Tenant (If you've ever used this email for work/school) #1 - Wrong Account (Easiest to check and fix) Start with Step 2 (Country/Region). If that's set to a major supported country and the feature is still missing, Step 3 (checking for a work tenant) becomes the overwhelming favorite. 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.11Views1like0Comments
Recent Blog Articles
No content to show