User Profile
NikolinoDE
Gold Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: OneDrive vs SharePoint
OneDrive vs SharePoint Feature OneDrive SharePoint Ownership Individual user Team / Organization Best For Personal work, drafts, lightweight sharing Team collaboration, enterprise content management File Sync Yes Yes Version Control Basic Advanced (with workflows, approval, retention policies) Integration Outlook, Teams, Windows Explorer Teams, Power Automate, Power Apps, Intranet Security & Governance User-level Enterprise-level (compliance, permissions, retention) Choose OneDrive when: Files are personal or in progress. You want a place for drafts before sharing. You need simple sync across devices. Choose SharePoint when: Files need to be team-owned. You require structured collaboration, workflows, or approval processes. Compliance, governance, and long-term storage matter. In Microsoft 365, Teams uses SharePoint on the back end for channel file storage, and OneDrive for chat file storage. In practice, both tools often complement each other rather than compete. The above information is the opinion of one user (my own), which has been substantiated with data/facts. Which of the two you use is at your discretion and depends on the needs of your company. My answers are voluntary and without guarantee! Hope this will help you.0Views0likes0CommentsRe: MS Excell application for Client database working under Windows XP.
To Understand the dependencies… Excel version: Which Excel is it built for? Excel 2003/2007 macros? Or newer? VBA/macros/ActiveX: Some ActiveX controls and VBA code written for XP-era Excel might break in modern Office. External dependencies: Does it connect to Access, ODBC, old drivers, custom DLLs? These often block migration. In some cases, you can adapt old VBA to work in modern Excel on Windows 10/11. However, there's no single "magic extra code" you add that will make everything just work—I recommend fixing by patching the few places where old code or objects no longer exist. My answers are voluntary and without guarantee! Hope this will help you too.14Views0likes0CommentsRe: Suggestion: Add =IMAGE() function to Excel 2016 & 2019
A couple of things to keep in mind about your request for =IMAGE() in Excel 2016 / 2019: Perpetual versions (2016/2019) are in fixed support mode. That means they only get security updates, not new feature updates. Microsoft typically reserves new functions (like =IMAGE(), =UNIQUE(), =FILTER(), etc.) for Microsoft 365 subscribers. The reasoning is partly technical (they’re maintaining different codebases) and partly strategic (feature innovation is the main incentive to move people to 365). So realistically, Microsoft will not back-port =IMAGE() (or any new dynamic array functions) into 2016/2019. What you can do: If you need something similar in 2016/2019, you can approximate =IMAGE() by: Using VBA to insert pictures linked to cells (works but requires macros). Using linked pictures (Copy > Paste Special > Linked Picture) for dynamic dashboards. Moving certain solutions to Excel for Web (free with a Microsoft account) where =IMAGE() is supported. How you can send feedback or suggestions to Microsoft (Excel / Office) From within Excel (or most Office apps) In Excel 2016 / 2019, go to File → Feedback (if available) or Help → Feedback. Choose “I have a suggestion” (or similar wording), describe your suggestion (i.e. adding =IMAGE() to 2016/2019), and submit. Use Microsoft’s Feedback Portal (web) Microsoft has a general feedback site: Feedback (Preview). Feedback Portal My answers are voluntary and without guarantee! Hope I was able to help you with this information.1View0likes0CommentsRe: Working with workbooks shared via Teams/Sharepoint
The URL you’re passing to URLDownloadToFile is not the direct file stream, but rather the HTML “viewer” link (or a redirect page). That’s why you’re getting a 4KB file (basically an HTML stub) instead of the actual .xlsx binary. Teams and SharePoint don’t hand over the raw file when you just grab the “copy link” from the UI. Instead, you get a sharing link that requires authentication and resolves via an HTML page. URLDownloadToFile doesn’t handle authentication cookies or redirects, so it saves that HTML instead of the file. Since you’re already working in Excel Desktop with Teams/SharePoint files, the simplest and most reliable method is: Sub SaveFromSharePoint() Dim wb As Workbook Dim localPath As String localPath = Environ("USERPROFILE") & "\Downloads\Test.xlsx" ' Open directly from SharePoint Set wb = Workbooks.Open("https://contoso.sharepoint.com/sites/TeamName/Shared Documents/General/Test.xlsx") ' Save a copy locally wb.SaveCopyAs localPath wb.Close SaveChanges:=False MsgBox "Saved to: " & localPath, vbInformation End Sub That way you skip the URLDownloadToFile issue entirely. 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: Macro to copy
To help the community support you more effectively, it would be useful if you could clarify a few things: What exactly is the source cell or range you want to copy from? Where do you want the value pasted (a specific sheet/cell, or dynamically chosen)? Should this copy happen automatically (e.g., when data changes), or only when you run a macro manually? Provide detailed information about the file (if known), including which Excel version (Excel 2016, 365 Home, etc.) was used to create the file? Whether the file extension has ever been changed (.xls, .xlsx, .xlsm, etc.)? Which operating system you are using to open the file, e.g., Windows 10 (21H1)? …and what medium is the file saved on (OneDrive, Sharepoint, hard disk, etc.)? If you can share a short description of your data layout (or a simplified example, rather than sending full files), it will be much easier for others to suggest a working macro. Many people here prefer not to receive files directly by email for safety reasons, but if you can describe or paste a sample setup, the community can usually provide a solution quite quickly. That way someone can give you code tailored to your exact need. Thank you for your understanding and patience Hope I was able to help you with this information.4Views1like0CommentsRe: Can't Open Draw.io In oneDrive
You're encountering a common issue with opening .drawio files directly from OneDrive or SharePoint Online. By default, these platforms don't support previewing or editing .drawio files online. However, there are effective workarounds to open and edit your diagrams without downloading them to your local computer. Open .drawio Files Online Use the Diagrams.net Web App The official Diagrams.net (formerly draw.io) web app allows you to open and edit .drawio files stored in OneDrive or SharePoint: Navigate to https://app.diagrams.net. Click on "File" > "Open From" > "OneDrive". Sign in to your Microsoft account if prompted. Browse to the location of your .drawio file and open it. This method allows you to edit your diagrams directly in the browser without downloading them. If you prefer working offline or need additional features, you can use the Diagrams.net desktop application: Download and install the Diagrams.net desktop app from https://www.diagrams.net. Open the app and sign in to your OneDrive or SharePoint account. Navigate to your .drawio file and open it. Any changes you make will be saved directly to your cloud storage. Ensure… Browser Compatibility: Ensure you're using a supported browser like Google Chrome or Microsoft Edge. Clear Cache: Sometimes, clearing your browser's cache can resolve loading issues. Permissions: Verify that you have the necessary permissions to access and edit the file in OneDrive or SharePoint. Additional Resources Add Diagrams to SharePoint with Free Draw.io Tool 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: Date taken option removed!
Some photographers have reported issues where OneDrive ignores the "Date Taken" metadata and instead sorts photos by the upload date, leading to disorganized files. This problem often arises when photos are uploaded via the OneDrive mobile app or web interface, which may not preserve the original EXIF data. Additionally, actions like marking photos as favorites can sometimes strip this metadata. Maybe you can try to use this Potential Workarounds: Use the OneDrive Desktop App: Uploading photos through the OneDrive desktop application may better preserve EXIF metadata compared to mobile or web uploads. Avoid Marking Photos as Favorites: Some users have found that marking photos as favorites can remove the "Date Taken" information. It's advisable to avoid this feature if maintaining metadata is crucial. Edit Metadata Before Uploading: Using tools like ExifTool or XnView MP, you can batch edit the "Date Taken" field to match the file's creation or modification date before uploading. This ensures that OneDrive has the correct metadata from the start. While these steps may not fully replicate the lost "Date Taken" feature, they can help mitigate the impact on your photo organization. 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: Save and close large files
Based on what you described (Windows 11, OneDrive for Business, large Excel/Word files, VBA macros). What’s happening is basically a race condition between: Office telling OneDrive "file is saved, sync it" You (or VBA) telling Office "close the file immediately" When the save and close come back-to-back, OneDrive/Office Upload Center sometimes doesn’t have time to update the cached copy before the file handle closes. That’s why you see “server version has been edited” or “please re-save” errors, especially on larger files. Manual habit (what you’ve already discovered) Do Ctrl+S (Save), wait a couple of seconds until the OneDrive icon shows a small green check, then close. Annoying, but works. VBA workaround (best option for automation) Here’s a drop-in VBA procedure you can add to any Excel file (or your Personal Macro Workbook), and then call it instead of ThisWorkbook.Close or ActiveWorkbook.Close. ' ================================ ' Safe Save-and-Close for OneDrive ' ================================ ' Call SafeClose ThisWorkbook ' or SafeClose Workbooks("MyFile.xlsx") ' instead of .Close Public Sub SafeClose(wb As Workbook, Optional DelaySeconds As Double = 2) On Error GoTo ErrHandler ' 1. Save explicitly wb.Save ' 2. Give OneDrive/Office Upload Cache time to catch up If DelaySeconds > 0 Then Application.Wait (Now + TimeSerial(0, 0, DelaySeconds)) End If ' 3. Close without asking again (already saved above) wb.Close SaveChanges:=False Exit Sub ErrHandler: MsgBox "Error closing workbook '" & wb.Name & "': " & Err.Description, vbExclamation End Sub Anywhere you would normally write: ThisWorkbook.Close SaveChanges:=True This way, the explicit Save happens, OneDrive has ~2 seconds to register it, and then the workbook closes without prompting. You can adjust the delay if needed (2–5 seconds for large files). Disable "Use Office applications to sync Office files" In OneDrive settings → Office tab → uncheck "Use Office applications to sync Office files I open". This makes OneDrive do the syncing instead of relying on the Office Upload Cache. Many users report it fixes weird save/close sync issues (but you lose some coauthoring features). 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: Subfolders not staying on top in one particular OneDrive directory only (web based)
In OneDrive for Business (web view) the way folders and files are sorted is controlled by the “Sort” and “Group by” settings in that particular folder view. Normally: With Sort → Name (ascending) and Group by → None, folders are pinned at the top followed by files. If Group by or Sort by Item type got changed, or if the view was customized, folders can become mixed in alphabetically with files — which is what you’re seeing in that one subdirectory. How you can maybe Fix It (in the web app) Go into the problem directory in OneDrive Online. On the toolbar above the file list, click Sort. Ensure it’s set to Name → Ascending. Then click View options (grid/list icon → top-right) → Group by → set to None. If it still mixes, check All documents → Manage view → Edit current view and make sure “Folders” is set to show first. If It Still Misbehaves Sometimes a folder has a “custom view” stuck to it (SharePoint behavior). In that case, go to All documents → Return to classic view (if available), reset sorting/grouping there, and return. Or create a new view for that folder: Click All documents → Save view as → give it a name. In that view, reapply the correct sort/group settings. Make it the default for that folder. Why only this one subdirectory? Because OneDrive/SharePoint can remember per-folder view settings. So one subfolder might have been accidentally toggled into a “flat alphabetical sort” view (files and folders all mixed), while the rest are still in the default “folders first” mode. 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: Excel: Desktop App correctly embeds images; web viewers like OneDrive often show them incorrectly.
The best practical workaround what I found at the time is: Create a hidden or dedicated sheet just for storing images When using workbook.addWorksheet(), make one sheet called "Images" (or similar). Insert all your images into this sheet using worksheet.addImage(). Don’t worry if this sheet is not meant for the end-user — you can hide it later. Add your real data sheets after the image sheet When you build the workbook with ExcelJS, create the "Images" sheet first. Then add your other sheets ("Report1", "Report2", etc.) where you place references/text. Do not reorder sheets later The bug in Excel Online is triggered when sheets containing images are reordered. So instead of generating them and then changing the order with something like workbook.worksheets.move(), generate in the correct order from the start. Optional: Hide the "Images" sheet So that users won’t see it, but the workbook still keeps images stable. Excel Online seems to break image references if sheets are reordered after images are embedded. By fixing the order at creation time (image sheet first → data sheets after), the file’s internal XML references (xl/drawings) stay consistent, so images display correctly in the browser. Here a short ExcelJS code sample that demonstrates this safe creation order (image sheet first, then ordered text sheets). const ExcelJS = require('exceljs'); const fs = require('fs'); async function createWorkbook() { const workbook = new ExcelJS.Workbook(); // 1. Create dedicated "Images" sheet FIRST const imgSheet = workbook.addWorksheet("Images"); // Load an image (example PNG file) const imageId = workbook.addImage({ filename: "logo.png", // or base64: "data:image/png;base64,...." extension: "png" }); // Insert image into the Images sheet imgSheet.addImage(imageId, { tl: { col: 0, row: 0 }, // top-left anchor ext: { width: 200, height: 100 } // size in pixels }); // 2. Add your "real" data/report sheets AFTER const report1 = workbook.addWorksheet("Report1"); const report2 = workbook.addWorksheet("Report2"); // Fill with some demo data report1.getCell("A1").value = "Report 1 Data"; report2.getCell("A1").value = "Report 2 Data"; // (Optional) You could add more images directly to these sheets if needed, // but avoid reordering sheets once created. // 3. (Optional) Hide the Images sheet so users don’t see it imgSheet.state = "hidden"; // 4. Save workbook await workbook.xlsx.writeFile("SafeWorkbook.xlsx"); console.log("Workbook created successfully!"); } createWorkbook(); Always create the "Images" sheet first, then create your “real” sheets in the final order you want to see. Do not reorder sheets afterward → that’s what triggers the bug in Excel Online. You can hide the image sheet so end users only see the data sheets. Hope this could help you a little0Views0likes0CommentsRe: Excel Formula Help
If you want specific columns (e.g., Name, Job Code, Module) Use CHOOSE inside FILTER: MRD ABC123 tab =FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!I:I),(DATA!G:G="MRD")*(DATA!F:F="ABC123"),"No matching data") SLRD ABC123 tab =FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!J:J),(DATA!G:G="SLRD")*(DATA!F:F="ABC123"),"No matching data") SBRD ABC123 tab =FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!K:K),(DATA!G:G="SBRD")*(DATA!F:F="ABC123"),"No matching data") ORD ABC123 tab =FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!L:L),(DATA!G:G="ORD")*(DATA!F:F="ABC123"),"No matching data") MPRD ABC123 tab =FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!M:M),(DATA!G:G="MPRD")*(DATA!F:F="ABC123"),"No matching data") FP XYZ123 tab (example with different job code) =FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!N:N),(DATA!G:G="FP")*(DATA!F:F="XYZ123"),"No matching data") Replace {1,2,3} with {1,2,3,4,5,...} and add more columns (e.g., DATA!C:C, DATA!D:D, etc.) if you need additional fields to appear in the tab. Just paste each formula into row 2 of the corresponding tab under your headers, and the results will spill down automatically. I'm currently working on Excel 2016, so please understand that I can't create a file or test the formulas. This way, each district tab always pulls all rows that match both criteria and lines them up properly, instead of showing just the first match. But I still hope it helps you🙂8Views0likes0CommentsRe: Excel Formula Help
If you want specific columns (e.g., Name, Job Code, Module) Use CHOOSE inside FILTER: MRD ABC123 tab =FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!I:I),(DATA!G:G="MRD")*(DATA!F:F="ABC123"),"No matching data") SLRD ABC123 tab =FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!J:J),(DATA!G:G="SLRD")*(DATA!F:F="ABC123"),"No matching data") SBRD ABC123 tab =FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!K:K),(DATA!G:G="SBRD")*(DATA!F:F="ABC123"),"No matching data") ORD ABC123 tab =FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!L:L),(DATA!G:G="ORD")*(DATA!F:F="ABC123"),"No matching data") MPRD ABC123 tab =FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!M:M),(DATA!G:G="MPRD")*(DATA!F:F="ABC123"),"No matching data") FP XYZ123 tab (example with different job code) =FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!N:N),(DATA!G:G="FP")*(DATA!F:F="XYZ123"),"No matching data") Replace {1,2,3} with {1,2,3,4,5,...} and add more columns (e.g., DATA!C:C, DATA!D:D, etc.) if you need additional fields to appear in the tab. Just paste each formula into row 2 of the corresponding tab under your headers, and the results will spill down automatically. This way, each district tab always pulls all rows that match both criteria and lines them up properly, instead of showing just the first match. I'm currently working on Excel 2016, so please understand that I can't create a file or test the formulas. But I still hope it helps you4Views0likes0CommentsRe: Excel Formula Help
Example: Pulling the Module column (Column I in DATA) In the Module column of MRD ABC123 (let’s say column D): =FILTER(DATA!I:I, (DATA!G:G="MRD")*(DATA!F:F="ABC123"), "No matching data") Explanation: DATA!I:I → MRD Module column (DATA!G:G="MRD") → District matches MRD (DATA!F:F="ABC123") → Job Code matches ABC123 "No matching data" → optional message if no match Example: Pulling another column (e.g., Employee Name in Column B) =FILTER(DATA!B:B, (DATA!G:G="MRD")*(DATA!F:F="ABC123"), "") Step-by-step for all columns on MRD ABC123 tab Decide which columns on your tab correspond to which columns on DATA. In each column, use: =FILTER(DATA!<COLUMN>, (DATA!G:G="MRD")*(DATA!F:F="ABC123"), "") Replace <COLUMN> with the column from DATA you want to pull. For other districts/tabs (SLRD, SBRD, etc.) Change the District and Module column: SLRD SLR123 Module (Column J in DATA): =FILTER(DATA!J:J, (DATA!G:G="SLRD")*(DATA!F:F="SLR123"), "") SBRD SBR123 Module (Column K in DATA): =FILTER(DATA!K:K, (DATA!G:G="SBRD")*(DATA!F:F="SBR123"), "") Notes Each column uses its own FILTER formula. The rows will automatically spill to match all rows from DATA that meet both criteria. This works in Excel 365 / Excel 2021+. My answers are voluntary and without guarantee! Hope this will help you.8Views0likes0CommentsRe: Excel dominance
Remove or disable Microsoft Excel If you don’t want Excel at all: On Windows 10 / 11 Press Windows Key + I → open Settings. Go to Apps → Installed Apps (or Apps & features). Find Microsoft Office or Microsoft 365 Apps in the list. Click Uninstall and follow the prompts. Note: If Excel came preinstalled, uninstalling it removes the whole Microsoft 365 Apps suite. If you only see "Microsoft Office Click-to-Run" or "Microsoft 365", that’s the one to uninstall. Change the default app for .ods files If you still want Excel available but don’t want it opening .ods files: Right-click on an .ods file. Select Open with → Choose another app. Select Open Office Calc (or Libre Office Calc, if you have it installed). Tick Always use this app to open .ods files. Click OK. Now .ods files will always open in Open Office instead of Excel. Prevent Excel from reappearing after reboot If Excel seems to come back on reboot: That usually means it wasn’t uninstalled, but just had shortcuts re-created. Once you uninstall Microsoft 365 Apps (step 1), it won’t reinstall itself unless: You have a vendor-supplied PC that pushes it back via manufacturer’s update tools. In that case, check your PC’s OEM updater (e.g., Dell SupportAssist, HP Support Assistant, Lenovo Vantage) and disable automatic app reinstalls. The text was created with the help of AI. 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.7Views1like0CommentsRe: Is the Excel Review -> Optimise feature available through Microsoft.Office.Interop.Excel
At this time…and so far i know... The “Optimize All / Optimize Sheet” wizard is not available via Microsoft.Office.Interop.Excel COM interfaces. There is no public API to invoke it. The publicly documented “Excel VBA / Interop / COM” libraries provide many controls over workbook content, formatting, calculation modes, etc., but nothing that appears to map to this new Performance/Optimize wizard tool. To automate similar performance improvements, you’ll have to build your own cleanup/optimization logic via Interop or use third-party libraries/tools. Here a example in VBA: see the attached file This way your client can bulk-clean an entire year’s worth of workbooks in one go. Back up the folder before running — this script overwrites files in place. Hidden sheets and custom styles will also be processed — if some styles are needed, comment out the st.Delete loop. Large folders may take a while (Excel has to open, process, save each file). Alternative you can choice a AddIn from Internet. 1. Inquire Add-in (built into Office Professional Plus / Microsoft 365 Apps for enterprise) Includes “Workbook Clean-up” under Inquire → Clean Excess Formatting. Not always installed by default, but can be enabled under COM Add-ins. 2. Third-party optimization add-ins Tools like Kutools for Excel, ASAP Utilities, and others include workbook cleanup functions. These are paid, but they can batch-process workbooks to reduce file size. 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.11Views0likes0CommentsRe: One Drive Keeps Coming Back
Uninstall OneDrive Completely Open PowerShell as Admin: # 64-bit Windows %SystemRoot%\SysWOW64\OneDriveSetup.exe /uninstall # 32-bit Windows %SystemRoot%\System32\OneDriveSetup.exe /uninstall After this, OneDrive should not reinstall unless you manually run setup. My answers are voluntary and without guarantee! Hope this will help you.26Views0likes0CommentsRe: Excel: Desktop App correctly embeds images; web viewers like OneDrive often show them incorrectly.
There doesn't seem to be a fix released by Microsoft yet (as far as I'm aware) that guarantees that images embedded via ExcelJS will display as correctly in Excel Online/OneDrive/SharePoint as they do in the desktop app. However, you can try some suggestions in Forums like, GitHub or StackOverflow. My answers are voluntary and without guarantee! Hope this will help you.32Views1like0CommentsRe: Delete Empty Rows Quick?
A simple VBA solution that does exactly what you want...at least I think so 🙂. Here’s a approach that: Deletes only rows that are completely empty across all columns. Leaves any row with at least one non-empty cell untouched. Works in Excel 2016 and Excel 365. The code is in the attached file and can be tested immediately. 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.2.2KViews0likes0Comments
Recent Blog Articles
No content to show