User Profile
NikolinoDE
Platinum Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Can a mobile app programmatically trigger the OneDrive mobile app?
Interacting with OneDrive Mobile App from Third-Party Apps 1. Directly Triggering the OneDrive Mobile App No Supported Method Exists: Microsoft does not provide any documented or supported mechanisms (like Android Intents, iOS URL schemes, or similar) for third-party apps to programmatically trigger the OneDrive mobile app to perform actions (e.g., creating folders or uploading files). Android: No Intent-based interactions are supported for OneDrive operations. iOS: No URL schemes (e.g., onedrive://) are published for file/folder creation or uploads. Rationale: Allowing third-party apps to directly invoke OneDrive’s UI for operations would bypass critical security controls (e.g., user consent, permissions) and create inconsistent experiences. 2. Supported Approach: Microsoft Graph API The Only Officially Supported Method: The Microsoft Graph API is the definitive, platform-agnostic solution for programmatic interactions with OneDrive/SharePoint. This includes: Creating folders Uploading files Managing permissions Querying content Access via REST API or SDKs (Android/iOS). Authentication: Requires OAuth 2.0 with the Files.ReadWrite.All or Sites.ReadWrite.All scope (for SharePoint). Users must authenticate and grant consent via Microsoft Identity. Mobile Integration: Use the Microsoft Graph SDKs for Android/iOS to streamline API calls, token handling, and error management. 3. Alternative: OneDrive Picker (Limited Scope) File/Folder Selection Only: The OneDrive File Picker allows users to select files/folders from OneDrive within your app (not trigger OneDrive’s app). It supports: Web and mobile (via OAuth). Read access (download), but not write operations (create folders/upload files). Not for Programmatic Writes: This is user-driven selection, not automation. 4. Deep Linking (View-Only) View-Only Links: You can generate deep links to open specific files/folders in the OneDrive mobile app (e.g., for viewing). For example: iOS: msauth://v2.0?path=/drive/root/children Android: https://onedrive.live.com/redir?path={encoded-path} Limitation: Only supports navigation, not creation/modification. Not for CRUD Operations: Deep links cannot create folders or upload files. Official Recommendations Use Microsoft Graph for Writes: For creating folders/uploading files, always use Microsoft Graph. This ensures: Compliance with Microsoft’s security model. Cross-platform consistency (Android/iOS/web). Access to advanced features (permissions, versioning, etc.). Avoid Undocumented Hacks: Reverse-engineering URL schemes/Intents violates platform policies and risks app rejection (Apple App Store/Google Play) or breaking with future updates. Leverage SDKs: Use the Microsoft Authentication Library (MSAL) and Graph SDKs for secure integration. Resources Graph API Documentation: Create a folder in OneDrive Upload files to OneDrive SDKs: Android SDK iOS SDK Authentication: MSAL for Android/iOS In summary: The Microsoft Graph API is the only supported method for programmatically creating folders/uploading files to OneDrive/SharePoint from mobile apps. No direct interaction with the OneDrive mobile app for these operations is officially supported. My answers are voluntary and without guarantee! Hope this will help you.0Views0likes0CommentsRe: sharedWithMe returns only one item
This is a known and subtle behavior difference between delegated (user) tokens and application-only tokens in Microsoft Graph, and it explains exactly what you’re seeing. Short answer… /drive/sharedWithMe does not fully work with application (client credentials) tokens. It is designed to return items shared with the signed-in user, and only delegated user context is fully supported. Graph Explorer uses delegated permissions, while your standalone app is using application permissions → hence only one item (or an incomplete set) is returned. Your permissions are correct Your request is valid The endpoint is not supported for application-only tokens This is expected behavior, not a bug. Final recommendation If your scenario is user-centric (which sharedWithMe is): Switch to delegated authentication My answers are voluntary and without guarantee! Hope this will help you1View0likes0CommentsRe: The close button seems to be not appearing for open knowledge agent
Based on what’s visible, this is a known UI rendering issue with the Knowledge Agent / Copilot pane in OneDrive for Business. Below are practical troubleshooting steps, followed by a clean problem description you can use for a support ticket if needed. What’s happening (from the screenshot) The Knowledge Agent sidebar is fully expanded The Close (X) / Collapse chevron is missing The left navigation is partially hidden There is no visible control to dismiss or collapse the chat pane Refresh does not restore the close button This confirms it’s not a user action issue — it’s a front-end UI bug. Why this happens This typically occurs due to one or more of the following: UI regression from a recent Microsoft 365 update Browser zoom / scaling issue (button rendered off-canvas) CSS or script blocked by extensions Tenant-side Copilot / Knowledge Agent rollout bug External user (EXT) context rendering issue Your screenshot shows Hello Suraj R [EXT]!, which is important — this happens more often for external users. Confirmed workarounds (these usually work) 1. Keyboard escape (most reliable) Click anywhere inside the chat pane, then press: Esc In many builds, this collapses the Knowledge Agent even when the button is missing. 2. Browser zoom reset (very common fix) Set browser zoom to 90% or 100% Maximize the window Hard refresh (Ctrl + F5) The close icon is often rendered outside the visible area. 3. Open OneDrive in a new tab (quick workaround) Right-click OneDrive → Open in new tab The Knowledge Agent usually loads collapsed by default 4. Try Edge InPrivate or Chrome Incognito This bypasses: Extensions Cached UI scripts If it works there → extension or cached UI issue. 5. Temporary URL reset trick Open OneDrive Manually append and remove a query string: ?view=files Press Enter This forces a UI redraw. Important note (likely root cause) Because the user is marked as [EXT], this is very likely a Microsoft bug affecting external users where: Copilot / Knowledge Agent loads Close control fails to render Microsoft has acknowledged similar issues in recent M365 UI updates. 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: Want a formula result to update across Sheets?
What you’re running into is a values vs formulas issue, not a calculation or Excel version problem. Short version: If you paste values, they will never update. To update across sheets, the cells must contain formulas, not pasted values. Let’s break it down clearly and then give you the correct way to do this. What’s happening now (why it doesn’t update) When you: Select multiple sheets Paste V (Paste Values) Excel is doing exactly what you told it to do: It pastes the current number It removes the formula (=Aux!B22) There is no longer a link to Aux So later, when you change Aux!B1: Aux!A22 updates Aux!B22 updates Other sheets do not update because they only contain a static value This is expected Excel behavior. What you actually want You want: One calculation sheet (Aux) Many sheets that stay linked to it When Aux changes → all sheets update automatically To do that, every target cell must contain a formula, not a pasted value. Correct way to do this (step-by-step) Keep your calculation in Aux Example: Aux!A22 = SUM(B1:B3) Optional helper cell: Aux!B22 = A22 Link other sheets with formulas (NOT values) Option A — Use grouped sheets (best if layouts match) Select all target sheets (Click first → Shift-click last) Click the destination cell (e.g. B22) Enter: =Aux!B22 Press Enter Ungroup sheets This inserts the formula into every selected sheet All sheets will now update automatically Verify it worked Click any target sheet and check the cell: Formula bar should show: =Aux!B22 If you see a number instead → it was pasted as a value and will never update. What will NEVER work (by design) Paste Special → Values Copy → Paste Values Drag-fill after pasting values Once the formula is removed, Excel has no reference to Aux anymore. If you need different sheets but same formula If every sheet should pull from Aux but stay independent: ='Aux'!$B$22 Use absolute references so nothing shifts. Summary Method Updates? Paste Values Never Formula =Aux!B22 Always Grouped sheets + formula Best solution 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.0Views2likes1CommentRe: Bank recon matching
Cleaner & faster Add two helper columns in BOTH sheets: Helper 1 – Normalized description =LOWER(TRIM(SUBSTITUTE(C5,",",""))) Helper 2 – Signed amount =IF(E5="DR",D5,-D5) Then your match becomes trivial: =XLOOKUP(G5,BANK!G:G,BANK!C:C,"",0) This is fast, stable, auditable. Excel Pattern (without helper columns) Build a logical match using FILTER In CBK!F5 (your “BANK Match” column), use: =LET(amt,D5,txt,C5,dir,E5,FILTER(BANK!C:C,(BANK!D:D=amt)*(BANK!E:E<>dir)*REGEXTEST(BANK!C:C,TEXTJOIN("|",,TEXTSPLIT(txt," "))),"")) 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: Hyperlinks not working on Macbook air
To resolve the hyperlink issue in Excel on your MacBook Air, follow these structured steps. The problem likely stems from macOS security permissions or Excel-specific settings: Step-by-Step Solution 1. Check File/Folder Permissions Right-click the PDF file or its containing folder → Get Info. Under Sharing & Permissions, ensure your user account has Read & Write access. If locked, click the lock icon (bottom-right), authenticate, and adjust permissions. 2. Grant Excel Full Disk Access Go to Apple Menu → System Settings → Privacy & Security → Full Disk Access. Ensure Microsoft Excel is listed and checked. If not: Click + → Navigate to /Applications/Microsoft Excel.app → Add it. Restart Excel after granting access. 3. Manually Insert Hyperlinks Instead of using the "Insert Link" tool, use the formula bar: Right-click the PDF in Finder → Copy "File.pdf" as Pathname. In Excel, select a cell and type: =HYPERLINK("Paste/Copied/Path/Here.pdf", "Display Text") Replace Paste/Copied/Path/Here.pdf with the actual path. 4. Reset Excel Preferences Quit Excel. Open Finder → Press Command + Shift + G → Paste: ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/ Delete com.microsoft.Excel.plist (backup first if needed). Empty Trash and restart Excel. 5. Clear Excel Cache In Finder, navigate to: ~/Library/Containers/com.microsoft.Excel/Data/Library/Caches/ Delete all files in this folder. Restart Excel. 6. Temporarily Disable Security Prompts (Testing Only) Go to System Settings → Privacy & Security → Security. Set Allow apps downloaded from to App Store (most restrictive). Revert to App Store and identified developers after testing. Manually open the PDF once via Finder to "trust" it, then retry the hyperlink. 7. Update or Reinstall Excel Update Excel: Open Excel → Help → Check for Updates. Reinstall Excel if issues persist: Uninstall Excel via Finder → Applications. Delete residual files: ~/Library/Containers/com.microsoft.Excel/ Download the latest version from the Mac App Store. If the issue persists after these steps, consider testing with a PDF in your Downloads folder (a trusted location) to rule out folder-specific restrictions. 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: Certain Excel files won't open on my laptop
With your permission, if I can recommend you, please always add specific information about your Excel version and operating system to your concerns. As well as, if possible or necessary, a file (without sensitive data) or photos. Information on where the file is, such as OnDrive or Sharepoint, is of advantage. In this way, you will come up with a proposed solution much faster and more precisely. This also makes it much easier for the helpers to provide the help that they would like to offer you. It helps both :). Here is a link with information on how you can quickly find a solution that is most suitable for you. Welcome to your Excel discussion space! Thank you for your understanding NikolinoDE I know I don't know anything (Socrates)9Views0likes0CommentsRe: Built an Android app for OneDrive duplicate detection (something I wish Microsoft offered natively)
Nice problem choice—this is a very real pain point for OneDrive + Android users, especially Samsung owners. A few thoughts, split into questions to strengthen adoption. Questions… You don’t need to answer all of these here, but they’re worth addressing in your Play Store listing or FAQ: 1. Privacy & permissions Is anything sent to your servers? 2. Rate limits / large libraries How does it behave with 100k+ photos? Does Graph API throttling slow scans significantly? 3. False positives Can users adjust sensitivity? 4. Video duplicates Any limits on video duration/size? 5. OneDrive account types Personal vs Business accounts? Multiple accounts supported? Nice work 🙂— this is exactly the kind of “why doesn’t the platform do this?” app that gains loyal users.9Views1like0CommentsRe: Advanced equations with multiple input values- tutorials arent helping :(
Sounds like you’re trying to tackle advanced Excel formulas with multiple input values, but the tutorials you’ve found are either too simple or confusing. Let’s break this down step by step. First, a few clarifying questions : Are your inputs all in separate cells or do you want to enter multiple values directly into a single formula? Are you trying to return a single result, or something like conditional calculations for each input? Are you comfortable using helper columns, or do you want everything in one big formula? In this link you will find some more information about it: Welcome to your Excel discussion space! Thank you for your understanding and patience Hope I was able to help you with this information. NikolinoDE I know I don't know anything (Socrates)16Views0likes0CommentsRe: Question with this forum itself
Thank you for confirming! Yes, on i Phones and other mobile devices, the button often appears at the bottom after scrolling, which can make it feel hidden. Your observation really illustrates why this layout can be confusing, and it highlights the U X challenge the team faces in balancing responsive design with discoverability.16Views0likes0CommentsRe: Question with this forum itself
No worries at all — you’re not an idiot! 🙂 Many users find the “Start a Discussion” button tricky to locate at first because of how the site adjusts for different screen sizes. On desktop it’s at the top, on mobile it’s often at the bottom. You’re definitely not alone in feeling unsure at first.18Views0likes0CommentsRe: Question with this forum itself
Thanks for sharing your experience! 🙂 That aligns perfectly with the responsive design behavior I described. On larger desktop windows, the button stays at the top, and the share buttons don’t obstruct anything — exactly as you’ve observed. The issues mostly appear on smaller viewports or when zoom/text scaling is applied.14Views0likes0CommentsRe: Disappearing Script Button
Thanks for the additional details! Your observations confirm the Excel for the Web rendering bug and provide useful extensions to it: Off-screen buttons & frozen panes: If a button is outside the visible area when the page loads, it often doesn’t render, even in frozen rows or columns. Dummy button behavior: The dummy button must be visible on load; otherwise, Excel’s Scripts UI doesn’t initialize. A simple tab switch alone won’t trigger it. Workaround with script button: Your approach of using the dummy button as a script that returns to the original sheet is very effective, as it reliably handles the timing issue. In short, your additions clarify the behavior further and confirm that this workaround is currently the most reliable approach.12Views0likes0CommentsRe: Pivot Table: Grouping doesn't work (tried almost everything)
If you want tell us…. What field you’re grouping (dates? numbers?) Whether the PivotTable uses the Data Model How the data is sourced (manual / CSV / PQ) This would allow for a more precise identification of the cause and the provision of targeted solutions. Welcome to your Excel discussion space! Thank you for your understanding and patience NikolinoDE I know I don't know anything (Socrates)18Views0likes1CommentRe: Getting the Same Range from an List of Sheets that Match a Variable
Core limitation… Excel functions like FILTER, VSTACK, LET, LAMBDA cannot loop through sheet names dynamically. So this cannot work natively: =VSTACK(A1:B10 from all sheets where Name="Bob") Excel formulas do not have a “foreach sheet” capability. VBA SOLUTION (Best if you already use VBA) If you’re comfortable with VBA and want formatting preserved: Sub CollectPersonRanges() Dim ws As Worksheet Dim tgt As Worksheet Dim nextRow As Long Dim person As String person = "Bob" Set tgt = Worksheets("Summary") nextRow = 1 For Each ws In Worksheets If ws.Range("A1").Value = person Then ws.Range("A1:B10").Copy tgt.Cells(nextRow, 1) nextRow = nextRow + 10 End If Next ws End Sub works well because… Simple, Keeps formatting, Fast, Clear logic. ------------------------------------------------------- Power Query (Not my strength, but the best possible solution) If: You have many sheets Sheet count changes You want a robust, maintainable solution Power Query is the right tool. This is exactly what Power Query is built for. 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: Hello, I can't open a file.
With your permission, if I can recommend you, please always add specific information about your Excel version and operating system to your concerns. Information on where the file is, such as OnDrive or Sharepoint, is of advantage. In this way, you will come up with a proposed solution much faster and more precisely. This also makes it much easier for the helpers to provide the help that they would like to offer you. It helps both :). Here is a link with information on how you can quickly find a solution that is most suitable for you. Welcome to your Excel discussion space! Thank you for your understanding NikolinoDE I know I don't know anything (Socrates)17Views0likes0CommentsRe: Disappearing Script Button
This is a real Excel for the Web rendering bug, and your observations are actually very diagnostic. You’ve already narrowed it down better than most people do. Below is a clear breakdown and what you can realistically do about it. This is a known (but inconsistently documented) Excel for the Web UI bug involving Office Scripts buttons not rendering on initial sheet load. Your “dummy button” workaround works because it forces the Scripts pane and button-rendering engine to initialize. Why?... Excel for the Web handles Script Buttons very differently from: Shapes Form controls Desktop VBA buttons Internally: Script buttons are rendered by a separate React-based UI layer That layer is lazy-loaded On some workbooks/sheets, it fails to initialize on first load When you: Switch to another sheet that already has a script button Excel initializes the Scripts UI When you return → the missing button finally renders Refreshing the browser resets the UI state, so the bug returns. This is why: Desktop Excel works fine Dummy button “fixes” it Zooming, scrolling, resizing does nothing Switching to a sheet without a script button does nothing Why one button disappears but the dummy doesn’t This usually happens when one or more of the following are true: The disappearing button is on a sheet that is: First sheet opened by default Hidden → then unhidden Loaded via a direct link to that sheet Excel Web sometimes fails to initialize scripts on the initial active sheet. The button is: Positioned partially off-grid Anchored to merged cells Anchored to filtered rows On a protected sheet (even loosely protected) Excel Web has layout race conditions during load. Workbook was: Originally created in Desktop Excel Heavily modified with VBA Saved multiple times before scripts were added This causes stale layout metadata that Web Excel misreads. Why Microsoft hasn’t “fixed” it yet Because: Office Scripts is still evolving This bug is intermittent It’s considered “non-blocking” internally The workaround (sheet switching) technically exists So it keeps slipping through release cycles. Workaround… Keep your dummy script button on a helper sheet. You accidentally found the most reliable fix. If you want to clean it up: Rename sheet to _Init or _Scripts Hide the sheet Leave one script button there forever Hidden sheets still initialize scripts. 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.1View1like2CommentsRe: Move based on value VBA
Simply copying the row causes formulas (like the one in column D) to re-point to the wrong cells on the destination sheet. It is the best-practice, production-ready version of your macro. It avoids Select, handles row deletion correctly, preserves your logic, and locks column D as values before moving the row so formulas never shift. Sub MoveCompletedProjects() Dim wsSrc As Worksheet Dim wsDst As Worksheet Dim lastSrcRow As Long Dim lastDstRow As Long Dim r As Long Application.ScreenUpdating = False Application.EnableEvents = False Application.Calculation = xlCalculationManual Set wsSrc = Worksheets("Deliverables") Set wsDst = Worksheets("Complete") ' Last used rows lastSrcRow = wsSrc.Cells(wsSrc.Rows.Count, "S").End(xlUp).Row lastDstRow = wsDst.Cells(wsDst.Rows.Count, "A").End(xlUp).Row ' Loop bottom-to-top to safely delete rows For r = lastSrcRow To 1 Step -1 If wsSrc.Cells(r, "S").Value = "Complete" Then ' Lock column D as values BEFORE moving wsSrc.Cells(r, "D").Value = wsSrc.Cells(r, "D").Value ' Copy row to destination wsSrc.Rows(r).Copy Destination:=wsDst.Rows(lastDstRow + 1) ' Delete source row wsSrc.Rows(r).Delete lastDstRow = lastDstRow + 1 End If Next r CleanExit: Application.ScreenUpdating = True Application.EnableEvents = True Application.Calculation = xlCalculationAutomatic End Sub No .Select or .Activate Bottom-to-top loop Formula-safe transfer Performance optimized Explicit worksheet references 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: Question with this forum itself
You’re not doing anything wrong. This is caused by responsive design behavior on the Tech Community site, which changes layout elements based on screen width, zoom level, and device type. What’s actually happening “Start a Discussion” is responsive, not fixed On desktop with sufficient viewport width, the button appears prominently near the top. On narrow viewports (mobile phones, small browser windows, high zoom levels), the site: Moves the button to the bottom of the page Or hides it behind secondary navigation This explains why: Desktop users see it clearly iPhone users only see it at the bottom Some users feel it’s “missing” entirely This is intentional responsive behavior — but arguably poor UX for a discussion-driven forum. Browser zoom and accessibility settings matter Even on desktop, the button can disappear from the top if: Browser zoom is >100% OS-level text scaling is enabled The window is snapped or not full-width From the site’s perspective, this looks like a “small screen.” Share buttons are position: fixed The left-side share bar: Uses a fixed overlay Does not collapse properly on small screens Can overlap content, especially on mobile or narrow layouts There is currently no user-side control to dismiss it. This is a design flaw, not user error. Why the confusion is understandable The primary action (“Start a Discussion”) is not consistently placed The site does not provide visual cues when it moves Mobile and desktop experiences are materially different No accessibility fallback exists for overlays In the End… Your experience is completely plausible and shared by others: Desktop users with wide screens won’t notice the issue Mobile and accessibility users absolutely will The current design favors layout aesthetics over discoverability However, I am confident that the Microsoft team is working on improving things here as well, as is so often the case...everything takes time. 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.2Views1like1CommentRe: pivot table
Unfortunately there is no single switch that restores the old PivotTable behavior. Is not a usage mistake, there is no full fix on Mac today. The only truly reliable Pivot experience remains Excel for Windows. Short-term: use menus and field list, not free dragging. Workarounds… Use the Field List checkboxes instead of drag-and-drop Not ideal, but more reliable on Mac now. Check the field → it defaults to Rows Then use the dropdown next to the field name: “Move to Report Filter” “Move to Column Labels” “Move to Row Labels” This avoids the “field disappears” problem entirely. Use the right-click / Control-click menu For advanced users, this is sadly the most stable method now. Right-click the field in the PivotTable Choose: Move to Filters Move to Rows / Columns Yes, it’s slower — but it’s consistent. Drag from the Field List, not from the Pivot itself Dragging fields inside the PivotTable grid is far more error-prone now. Best practice on Mac: Only drag fields within the Field List pane Pause briefly when hovering over a target area (Filters / Rows / Columns) Excel now needs an annoying “hover delay” to register the drop zone. Resize the Field List pane (this matters) A weird but real workaround: Make the Field List pane wider Ensure all four zones (Filters, Columns, Rows, Values) are fully visible When zones are cramped, Excel Mac is much more likely to interpret a drag as a delete. If PivotTables are core to your work, use Excel for Windows If PivotTables are mission-critical: Run Excel for Windows via: Parallels Desktop VMware Fusion Windows 365 (cloud PC) Many power users on Mac have quietly gone this route. If I may offer one final suggestion, please also send feedback to Microsoft. The more people complain, the greater the chance that Microsoft will take this issue seriously and potentially make changes. 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.0Views1like1Comment
Recent Blog Articles
No content to show