User Profile
NikolinoDE
Platinum Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: can't export excel to pdf.
If the regular “Export to PDF” feature in Excel Online isn’t working, you can still create a PDF using your browser’s Print function. This works well in most cases. On Desktop (Chrome, Edge, etc.): Open your Excel file in Excel Online (in the browser). Click on File > Print > Print (don’t choose “Download as PDF” if that’s giving errors). A print preview will load – wait until it finishes loading. The browser's print dialog will open. In the print dialog: Set the Destination / Printer to: "Save as PDF". Adjust settings like pages, layout, scaling, etc., if needed. Click Save and choose where to save the PDF on your computer. On iPhone / iPad (iOS): If you’re using Excel Online in Safari or Chrome: Tap the Share icon (a square with an arrow pointing up). Choose Print. In the print preview, zoom in on the preview with two fingers – this opens the document as a PDF. Then tap Share again to: Save to Files Send via email Or open in another app (e.g., Books or Drive) If that still doesn't work: There might be a problem with: your browser's cache the specific Excel workbook or a temporary issue with Excel Online If needed, you can also try: opening the file in Google Sheets and exporting to PDF from there or downloading it and opening it in Excel desktop My answers are voluntary and without guarantee! Hope this will help you.2Views0likes1CommentRe: Onedrive file sync issue
OneDrive is basically “confused” about the state of your files because you hit a storage limit and then tried to reset. When OneDrive restores deleted files after a reset, it’s usually because it’s syncing from the cloud version, which still has the old files. Let’s carefully work through a step-by-step approach to fix this without risking your files. Check OneDrive Online Go to OneDrive.com and log in. Check whether the files you deleted are still in the cloud. If they are there, that’s why they keep coming back. If they’re not there, the problem might be local sync cache corruption. Pause Syncing Before making any changes, pause OneDrive sync: Click the OneDrive icon in your taskbar. Click Help & Settings → Pause syncing → 2 hours. Backup Locally Make a copy of the folder you want to keep outside of the OneDrive folder (e.g., on your desktop or another drive). This ensures nothing is accidentally deleted during the reset or resync process. Fully Reset OneDrive Sometimes a standard reset doesn’t clear corrupted local caches. Here’s a thorough reset: Close OneDrive completely (from the system tray → Exit). Press Win + R → type: %localappdata%\Microsoft\OneDrive\onedrive.exe /reset → Press Enter. Wait a few minutes. Check the taskbar to see if OneDrive starts. If it doesn’t start automatically, manually start it: %localappdata%\Microsoft\OneDrive\onedrive.exe This clears the local sync cache, which often fixes stuck or looping syncs. Clear Conflicting Files After reset, do not immediately copy files back into the OneDrive folder. Rename your local OneDrive folder (e.g., OneDrive_old) as a backup. Start OneDrive and choose a new folder to sync to. Move only the files you want synced from your backup folder to the new OneDrive folder gradually, checking that sync works. Check Storage Make sure you now have enough OneDrive storage: OneDrive needs at least a few GB of free space for syncing to operate smoothly. If your total storage is still close to full, sync may fail again. If after all of this OneDrive still refuses to sync, there’s a more nuclear option: unlink your account completely and set it up fresh: Right-click the OneDrive icon → Settings → Account → Unlink this PC. Sign in again and select a new folder for syncing. Copy files into the new OneDrive folder. 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.0Views1like0CommentsRe: Hide spesific folder from OneDrive synk all users
OneDrive does not have a native “exclude subfolder from sync” policy. The sync client only supports: Excluding certain file types/extensions (Block syncing of specific file types via Group Policy/Intune). Preventing specific folders/libraries from being synced at all (like excluding a whole document library in SharePoint/Teams). Controlling known folder move (Desktop, Documents, Pictures). But not: “exclude this one subfolder inside OneDrive for all users.” That’s why you only find manual guidance (right-click → “Choose folders to sync” in OneDrive client). if I may recommend… if your app must write to OneDrive, use the file type block policy to prevent those temp/working files from syncing. If you control the app, better to move its working directory outside of OneDrive altogether. 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.8Views1like0CommentsRe: Conditional Formatting for Spilled Arrays
Maybe this will help you a bit. Code in the workbook module. I included... CreateExpandedNamedRange — creates or updates a workbook-level named range that refers to an explicit start:end inside a container range (safe fallback to a single-cell if requested size doesn't fit). UpdateCF_AppliesTo_FromNamedReferences — scans conditional formatting rules and, where it finds a formula that contains a named range, updates that rule's AppliesTo to the named range's current RefersToRange. CreateExpandedNamedRangeAndUpdateCF — wrapper to create a named range and immediately update CF rules (convenience). Detailed comments, usage examples, and safety notes inside the module. My answers are voluntary and without guarantee!40Views0likes3CommentsRe: Excel Paste as Image Issue
When you Paste as Picture from Excel, instead of pasting just the visible cell range, Excel creates a large bounding box that covers the entire original sheet area (with your selected cells anchored at the top left). That’s why you always have to crop away the empty white/transparent region. This usually indicates a rendering bug or setting issue in Excel. Here are several fixes/workarounds you can try: 1. Use “Copy as Picture” instead of Paste Special → Picture Select your cells. Go to Home > Copy > drop-down > Copy as Picture… In the dialog, choose: As shown on screen Picture Paste into PowerPoint/Excel → this usually avoids the oversized bounding box problem. 2. Disable hardware graphics acceleration Sometimes the oversized paste box comes from Excel’s graphics engine. Go to File > Options > Advanced > Display Check Disable hardware graphics acceleration Restart Excel and test again. 3. Paste using “Picture (Enhanced Metafile)” Instead of “Picture (U)” or bitmap, try Picture (Enhanced Metafile) in Paste Special. This usually creates a tighter bounding box around the selection. 4. Try pasting into PowerPoint with “Keep Source Formatting” In PowerPoint, instead of directly pasting as a picture, paste normally → then choose Paste Options > Picture. Sometimes PowerPoint crops better than Excel’s native paste. 5. Update or Repair Office This is sometimes a known bug in certain Office 365 builds. If nothing works: Run Office → Account → Update Options → Update Now. If already updated, try a Quick Repair or Online Repair. The most reliable fix is using “Copy as Picture” (Home → Copy → Copy as Picture) instead of Paste Special → Picture. That should give you exactly the cropped range with no extra whitespace. 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: No puedo abrir mi Excel, ningún archivo.
Te dejo un checklist de pasos que suelen resolver este problema (en orden, prueba uno y si no funciona pasa al siguiente): 1. Restablecer la configuración de Excel Cierra Excel. Pulsa Win + R, escribe: excel /safe (ya lo hiciste). Ahora: Ve a Archivo > Opciones > Avanzadas y desactiva “Ignorar otras aplicaciones que usen DDE” (esta opción suele causar que los archivos no se abran). 2. Eliminar claves de registro dañadas (reseteo de perfil de Excel) Esto no borra tus archivos, pero restablece las preferencias de Excel. Cierra Excel. Pulsa Win + R, escribe regedit y entra al Editor del Registro. Navega a: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel (16.0 corresponde a Office 365). Renombra la carpeta Excel a Excel.old. Abre Excel normalmente: se regenerará esa clave limpia. 3. Reparación de Office Online Aunque lo reinstalaste, prueba la reparación online completa: Panel de Control → Programas → Office 365 → Cambiar. Selecciona Reparación en línea. (Esta opción corrige archivos corruptos que no se solucionan solo reinstalando). 4. Actualizar controladores gráficos / desactivar aceleración por hardware Abre Excel en modo seguro. Ve a Archivo > Opciones > Avanzadas > Mostrar. Activa “Deshabilitar aceleración de gráficos por hardware”. Reinicia Excel normalmente. 5. Revisar antivirus / software de terceros Algunos antivirus bloquean Excel al cargar. Desactiva temporalmente el antivirus y prueba. Si abre, crea una excepción para Excel en el antivirus. Te recomiendo empezar por desactivar DDE y luego renombrar la clave de registro, son las soluciones más comunes. ¡Mis respuestas son voluntarias y sin garantía! Espero que esto te ayude. ¿Te resultó útil la respuesta? ¡Márcala como la mejor respuesta y dale a "me gusta"! Esto ayudará a todos los participantes del foro.0Views0likes0CommentsRe: Doing a search and replace on all embedded hyperlinks in a spreadsheet
The key issue is that Excel’s standard Find & Replace doesn’t search the actual hyperlink behind a cell’s displayed text. It only searches the visible content. So if a cell says "Click here" but links to file://fs-prd/etc/..., a normal search for "file://fs-prd" won’t find it. You can create a list (with VBA code) to display all the hyperlinks in a sheet and then modify them manually. The code works like find function. Sub ListHyperlinks() Dim ws As Worksheet Dim hl As Hyperlink Dim outputRow As Long ' Change this to the sheet where you want the list Set ws = ActiveSheet ' Start listing from row 1 in columns A and B outputRow = 1 ws.Cells.Clear ' optional: clears sheet to make room ' Header ws.Cells(outputRow, 1).Value = "Text Displayed" ws.Cells(outputRow, 2).Value = "Hyperlink URL" outputRow = outputRow + 1 ' Loop through all hyperlinks For Each hl In ws.Hyperlinks ws.Cells(outputRow, 1).Value = hl.TextToDisplay ws.Cells(outputRow, 2).Value = hl.Address outputRow = outputRow + 1 Next hl MsgBox "All hyperlinks have been listed in columns A and B." End Sub If you open the file in Excel Desktop App (not in the browser/Excel for the web), the macro will run normally. Macros do not run in Excel for the web, so you must use the desktop version. My answers are voluntary and without guarantee! Hope this will help you4Views0likes0CommentsRe: Macro to copy
So far i understand… Requirements : Search from row 1 downward in columns O (Code), P (Units), Q (Stock Holding). Find the oldest row where: Column O = saleCode Column P = saleUnits Column Q is numeric and positive Ignore text, zero, or negative numbers Copy the value from Q to Y in the sale row After copying, mark the source cell as inactive: Prefix with apostrophe (') Font color red, fill color yellow Here’s a VBA macro: Sub CopyStockHoldingToSale() Dim ws As Worksheet Dim saleRow As Long Dim saleCode As String Dim saleUnits As Double Dim targetRow As Long Dim sourceRow As Long Dim lastRow As Long Dim cellValue As Double ' Set worksheet (change as needed) Set ws = ThisWorkbook.Sheets("Sheet1") ' Define the row where the sale is recorded saleRow = 7 ' Change to the row where the sale occurs ' Get sale details saleCode = ws.Cells(saleRow, "O").Value saleUnits = ws.Cells(saleRow, "P").Value targetRow = saleRow ' Copy to column Y in the same row ' Find the last row with data in column O lastRow = ws.Cells(ws.Rows.Count, "O").End(xlUp).Row ' Loop from top to bottom to find the oldest matching entry For sourceRow = 1 To lastRow ' Check code and units match If ws.Cells(sourceRow, "O").Value = saleCode And _ ws.Cells(sourceRow, "P").Value = saleUnits Then ' Only consider numeric and positive values in Q If IsNumeric(ws.Cells(sourceRow, "Q").Value) Then cellValue = CDbl(ws.Cells(sourceRow, "Q").Value) If cellValue > 0 Then ' Copy value to target cell in column Y ws.Cells(targetRow, "Y").Value = cellValue ' Format the source cell as inactive With ws.Cells(sourceRow, "Q") .Value = "'" & cellValue ' Prefix with apostrophe .Font.Color = vbRed .Interior.Color = vbYellow End With Exit For ' Stop after the first match End If End If End If Next sourceRow ' Optional: Message if no match found If ws.Cells(targetRow, "Y").Value = "" Then MsgBox "No matching positive stock holding found.", vbExclamation End If End Sub You can upgrade this macro to automatically trigger whenever a value is entered in Columns V or W, so you don’t have to run it manually every time. This would fully automate your workflow. Here the auto trigger code: Private Sub Worksheet_Change(ByVal Target As Range) Dim ws As Worksheet Dim saleRow As Long Dim saleCode As String Dim saleUnits As Double Dim targetRow As Long Dim sourceRow As Long Dim lastRow As Long Dim cellValue As Double Set ws = Me ' Refers to this sheet ' Only trigger if change happened in column V or W If Intersect(Target, ws.Range("V:W")) Is Nothing Then Exit Sub ' Determine the row where the change happened saleRow = Target.Row targetRow = saleRow ' Copy to column Y in the same row ' Get sale details from columns O and P in the same row saleCode = ws.Cells(saleRow, "O").Value saleUnits = ws.Cells(saleRow, "P").Value ' Find last row with data in column O lastRow = ws.Cells(ws.Rows.Count, "O").End(xlUp).Row ' Loop from top to bottom to find the oldest matching entry For sourceRow = 1 To lastRow If ws.Cells(sourceRow, "O").Value = saleCode And _ ws.Cells(sourceRow, "P").Value = saleUnits Then If IsNumeric(ws.Cells(sourceRow, "Q").Value) Then cellValue = CDbl(ws.Cells(sourceRow, "Q").Value) If cellValue > 0 Then ' Copy value to target cell in column Y ws.Cells(targetRow, "Y").Value = cellValue ' Format the source cell as inactive With ws.Cells(sourceRow, "Q") .Value = "'" & cellValue .Font.Color = vbRed .Interior.Color = vbYellow End With Exit For End If End If End If Next sourceRow End Sub My answers are voluntary and without guarantee! Hope this will help you.0Views0likes2CommentsRe: o365 programs not recognizing Jabber for tel: links
There are some caveats when it comes to integration with tel: and callto: links inside Office apps. Office apps (Word, Excel, Outlook, PowerPoint) don’t always honor the Windows default for tel: / callto:. They sometimes force integration with Microsoft Teams, Skype for Business, or Lync. Even if Jabber is set correctly in the registry, Office may redirect links to Edge or a Microsoft UC client. This is by design in some builds — Microsoft assumes Teams is the default calling app. This is why you saw behavior like: first click opens Jabber, subsequent clicks open Edge → Office caches or overrides the handler…in the end you need to fight against Office’s tendency to prefer Teams/Skype for tel: links. Suggested solutions that could potentially provide help in a corporate environment. Confirm Jabber Version → Use the latest Cisco Jabber (14.1+), as earlier builds had issues with Windows 11 integration. Set Defaults at OS Level → In Windows 11: Go to Settings → Apps → Default apps → Choose defaults by protocol Set TEL and CALLTO to Cisco Jabber. Disable Office Overrides: In Teams / Skype for Business clients, disable the option “Register as the default calling app” if present. In registry, use DisabledProtocolHandlerRegistrations under HKEY_CURRENT_USER\Software\Microsoft\Office\<version>\Lync to stop Office apps from re-claiming the tel: handler. Deploy via GPO/Intune → Push registry fixes enterprise-wide to keep Jabber as the handler. Fallback → If deep Office integration is critical (e.g. “click-to-dial” directly in Outlook contacts), Cisco generally recommends using Webex App (which has more active development) instead of Jabber, since Microsoft has moved to tighter Teams integration. My answers are voluntary and without guarantee! Hope this will help you.3Views0likes0CommentsRe: User Microsoft 365 Apps Freeze when Trying to Save
To isolate the culprit, try doing these in controlled steps. Document which step “breaks” or “works”. Test Purpose What to Observe / What Next Open Office in Safe Mode (hold Ctrl while launching Word/Excel) To disable all add-ins / customizations If saving works (no freeze), it strongly implicates add-ins or extensions. Microsoft Learn+2Microsoft Learn+2 Disable all COM / VSTO / Excel / Word add-ins Even if Safe Mode helps, you’ll need to find the offender Under File → Options → Add-ins, disable COM add-ins first, then Excel/Word add-ins. Test Save / Save As. Microsoft Learn+2SoftwareKeep+2 Perform a Clean Boot / minimal startup Removes interference from third-party services or shell extensions If freezing goes away, you can re-enable services incrementally to find the culprit Microsoft Learn Test saving to a completely local folder (not OneDrive-synced folder) To see if the cloud / sync side is involved If Save works locally but not in OneDrive, that local vs cloud boundary is critical Use a different user profile on the same machine To isolate whether it’s user-specific settings If a freshly created user account does not have the issue, then the old profile has something problematic (e.g. registry settings, Office config) Disable AV / security real-time scanning temporarily To test whether the antivirus is interfering with file operations If the freeze disappears when AV is off, this is a major clue Use ProcMon / File Monitor / Process Explorer To see what process is hanging or blocking the save E.g. capture events during Save/Save As and see which DLLs or hooks are involved Capture Office / Fiddler / diagnostic logs Microsoft support often asks for logs when Office freezing / stuck on OLE / Save issues Use Office’s diagnostic logging and Fiddler (if saving to cloud endpoints) to see where the delay stalls My answers are voluntary and without guarantee! Hope this will help you.5Views0likes0CommentsRe: How to resolve "Fix folder issues to sync x items"?
That message (“Fix folder issues to sync 108 items”) generally indicates that some files or folders under your OneDrive (or OneDrive for Business) sync tree are failing to sync correctly. Possible causes include: Filename or path length conflicts, or illegal characters Permissions (OneDrive can’t access or write to them) The item is on a removed/externally unmounted volume Conflicts or inconsistencies in the local file database Storage limits, quotas, or file-locking OneDrive internal corruption or cache issues Microsoft’s advice includes unlinking/relinking or resetting OneDrive. Fix OneDrive sync problems on Mac But before you do that, it’s often better to identify which specific items are causing the trouble and fix just those. Try to locate a few of those problematic file names (like pj-93-book-04.jpg) in Finder / Terminal Inspect their permissions, locked status, path, parent folders Rename / temporarily move them to test if they clear the sync error If that doesn’t help, back up your local OneDrive folder (just in case), then unlink + re-link, or reset OneDrive After re-syncing, re-add subfolders gradually If errors reappear, check logs to see which new files are failing 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: Syncing Minecraft Worlds to Onedrive
Minecraft saves are constantly updating and OneDrive can: cause sync conflicts (two versions of the same file), risk world corruption if you play before syncing finishes, slow down saves due to background uploads. It’s safer to keep worlds local and use OneDrive only for backups, not live sync. My answers are voluntary and without guarantee!27Views0likes0CommentsRe: Excel formula stopped working
Quick checklist (try these first) Calculation mode is set to Manual Go to Formulas → Calculation Options → make sure Automatic is selected. After switching to Automatic, press F9 (recalculate) or Ctrl+Alt+F9 (force full recalculation). Excel was left in Manual by another workbook Calculation mode can be carried between workbooks. Set it to Automatic, save the workbook, close Excel and re-open the file. Table auto-fill / calculated column behaviour turned off (if you use Excel Tables) File → Options → Proofing → AutoCorrect Options → AutoFormat As You Type → ensure “Fill formulas in tables to create calculated columns” is checked. Also check File → Options → Advanced → Editing options → Enable fill handle and cell drag-and-drop and Extend data range formats and formulas. If none of these helps, please provide precise details about the file. Excel version, operating system, storage medium, Excel file extension, and if possible, include the file (without sensitive data), so you can also see the formula. 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.6Views0likes0CommentsRe: Formula to calculate year of study
A “year of study” is basically: Current Year of Study = (Years since start) + 1 If your start date is in cell A2, you can use: =DATEDIF(A2, TODAY(), "y") + 1 If your institution considers the year change on a specific month (e.g. September), you can tweak it. For example, if academic years start on September 1st, use: =YEAR(TODAY()) - YEAR(A2) + IF(MONTH(TODAY())<9, -1, 0) + 1 If you also want to stop counting beyond the course’s official end date (say in B2), you can wrap it in MIN: =DATEDIF(A2, MIN(TODAY(), B2), "y") + 1 That way, if today is beyond the end date, it just shows the final year. 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.19Views1like0CommentsRe: Have multiple CONVERT cells update when any one cell's value is changed
If I understand correctly, the inserted file should work as you wish 🙂 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.27Views0likes0CommentsRe: Working with workbooks shared via Teams/Sharepoint
When you grab a “copy link” from Teams/SharePoint, that’s a sharing link meant to open in the browser (Excel Online). VBA can’t run there. If you want to open the file directly in Excel Desktop via VBA, you need to use the native SharePoint/OneDrive path instead of the web “sharing link”. Sharing link: Looks like https://tenant.sharepoint.com/:x:/r/sites/... → opens in browser, no VBA. Direct SharePoint/OneDrive path: Looks like https://tenant.sharepoint.com/sites/TeamName/Shared Documents/General/Test.xlsx → opens in Excel Desktop when used with Workbooks.Open Or, if you have the OneDrive sync client running, you can use the local sync path like: C:\Users\<you>\OneDrive - Contoso\TeamName\General\Test.xlsx That way, Excel opens the real file in Desktop and your VBA works normally. Example VBA: Open in Desktop and Save Copy. Sub SaveFromSharePoint() Dim wb As Workbook Dim localPath As String Dim spPath As String ' Local path for saving a copy localPath = Environ("USERPROFILE") & "\Downloads\Test.xlsx" ' Use the full direct SharePoint document library URL spPath = "https://contoso.sharepoint.com/sites/TeamName/Shared Documents/General/Test.xlsx" ' Open in Desktop Excel Set wb = Workbooks.Open(spPath) ' Save a copy locally wb.SaveCopyAs localPath wb.Close SaveChanges:=False MsgBox "Saved to: " & localPath, vbInformation End Sub To get the direct URL: Go to the document library in SharePoint (not just Teams chat → Files). Right-click the file → Details → Copy the full path from the properties pane. (It should end in .xlsx and not have ?web=1 at the end). Hope this will help you.0Views0likes0CommentsRe: Conditional Formatting multi rule help!
For the green rule, you want the Patient Name cell (column D) to turn green if: There is a date in the injection column (F), and There is a value in the prescription received column (O). Formula for Green: =AND($F13<>"",$O13<>"") Hope this will help you. Was the answer useful? Mark as best response and like it! This will help all forum participants.46Views1like1CommentRe: Avery Word Template – Text Boxes Not Linked, But Typing in One Moves Content in Others
Does your client’s document show “Compatibility Mode” in the title bar when opened? That’s the biggest clue whether the template itself is tripping Word’s layout engine. If the Avery template shows “Compatibility Mode” in the Word title bar, that means it’s an older .doc format file. File → Save As → “Word Document (*.docx), This rewrites the file to the modern layout engine. My answers are voluntary and without guarantee! Hope this will help you.18Views0likes0CommentsRe: Add secure additional workbook and worksheet protection Use MS account
Excel only gives you two main built-in protection methods: Worksheet/Workbook protection with a password → (weak, easy to crack, mostly for accidental edits). File-level encryption with a password (File → Info → Protect Workbook → Encrypt with Password) → (stronger, but still password-based). Enterprise features like Azure Information Protection / Purview / IRM → (very secure, but requires enterprise subscription + admin setup). At present, there’s no way to natively tie workbook/worksheet protection to a Microsoft Account login without using Azure Information Protection / Purview. Microsoft hasn’t built that exact "identity-based protection" option into personal or standard Excel — protection is either password-based (local) or cloud-managed via enterprise licensing. The “identity-based encryption” you’re describing would require Excel to request decryption keys from Microsoft’s key service every time you open a file, tied to your Microsoft Account session. That’s exactly what Azure RMS / IRM does today, but not what personal Excel does out of the box. If you want to share Excel files securely without weak password protection but without full enterprise rights management, here are the most realistic current options: Store the workbook in OneDrive or SharePoint, share via MS account permissions Use "Encrypt with Password" + Require MS Account for access IRM / Purview (if you’re in a corporate environment) What you’re describing is actually a feature request that would sit in between “weak password protection” and “enterprise IRM”. That doesn’t exist in Excel today. The closest is storing/sharing files through OneDrive/SharePoint with account restrictions, or using IRM in Microsoft 365 Enterprise. My answers are voluntary and without guarantee! Hope this will help you.5Views0likes0Comments
Recent Blog Articles
No content to show