📋  Quick reference table at the bottom. If you are in a hurry, jump to Part 2 for a one-line fix for each gotcha. Come back to Part 1 for the full explanation when you have time.

#1  The file opens read-only and I can't edit it

😕  What happens: You click a file and the toolbar is greyed out. Everything looks right but you cannot type.

🔍  Why: The file may have opened in View mode rather than Edit mode, or you were given view-only sharing permissions, or the file was opened from a download rather than from OneDrive or SharePoint.

✅  Fix: Click the Edit button or pencil icon that appears near the top of the browser window to switch to editing mode. If there is no Edit button, check your sharing permissions - you may only have view access. If you downloaded the file and opened it locally, close it, go to OneDrive or SharePoint, and open it from there instead.

#2  Macros are not running / the file asks me to enable macros

😕  What happens: You open a .docm or .xlsm file and macros do not run. The file may show a yellow warning bar, or simply nothing happens when you click a macro button.

🔍  Why: VBA macros are disabled in all browser-based Office apps - this is by design and cannot be changed. The web versions of Word, Excel, and PowerPoint do not support macro execution regardless of license level.

✅  Fix: E1 does not include the desktop Office apps where macros run. If your workflow relies on macros, contact IT - they can advise on alternatives such as Power Automate, which can automate many of the same tasks without macros and works within your E1 license.

#3  I keep pressing Ctrl+S and nothing seems to happen

😕  What happens: You press Ctrl+S out of habit and either nothing happens or the browser's Save Page dialog opens instead of saving your document.

🔍  Why: Files stored in OneDrive or SharePoint save automatically as you type. Ctrl+S is not needed and in some browsers it triggers a browser-level save (which saves the web page, not your document).

✅  Fix: Look at the top of the browser window for a Saved indicator or the last save timestamp - your document is already saved. You do not need to press anything. If you want to force a manual save, use File → Save inside the Office web app - do not use the browser's Ctrl+S shortcut.

#4  Printing from the browser makes the layout look wrong

😕  What happens: You press Ctrl+P to print and the browser's print dialog opens. The preview looks nothing like the document - margins are wrong, content is cut off, or pages are missing.

🔍  Why: Ctrl+P triggers the browser's print function, which renders the page as a website - not as a formatted Word or Excel document. The browser does not know about your document's page layout, margins, or print areas.

✅  Fix: Use File → Print inside the Office web app toolbar instead of Ctrl+P. This uses Microsoft's own print rendering which respects your document formatting. Alternatively, for complex print jobs, save the file as a PDF first (File → Save As → Download as PDF) and print from the PDF.

#5  A document uses a custom font and it looks completely different

😕  What happens: Someone sends you a file that looks fine on their screen but on yours the font has been substituted - words may overlap, spacing looks wrong, or it looks unprofessional.

🔍  Why: The browser can only display fonts that are installed on your computer or available as web fonts. If a document uses a custom or specialty font that is not on your system, the browser substitutes the closest available font - which can shift text layout significantly.

✅  Fix: For your own documents, stick to standard web-safe fonts that display reliably everywhere: Calibri, Arial, Times New Roman, Georgia, or Verdana. If you need to share a document that uses a specific font and must look exactly right, export it as a PDF - PDFs embed the font and display correctly regardless of what fonts the recipient has installed.

#6  The file keeps opening as read-only even after I edited it before

😕  What happens: You edited a file yesterday but today it opens read-only again. Or you try to edit and get a message saying someone else is editing.

🔍  Why: Two common causes: another person has the file open in a way that locks it (less common in web editing), or the SharePoint library requires check-out before editing - meaning only one person can edit at a time and you must formally check it out first.

✅  Fix: Click the editing indicator near the top of the browser - it usually shows who else has the file open. If it is just you, try refreshing the page. If check-out is required, look for a Check Out button in the toolbar - click it to take exclusive edit access, and click Check In when done. If the file is locked by someone who is no longer actively editing, contact them or IT to release it.

💡  Co-authoring vs check-out: Most SharePoint libraries allow real-time co-authoring where multiple people can edit simultaneously. Libraries set to require check-out do not - only one editor at a time. Your IT admin controls this setting.

#7  Pasting text drops all the formatting

😕  What happens: You copy formatted text from another document or website and paste it with Ctrl+V - and it arrives as plain text with no formatting.

🔍  Why: The default paste behaviour in browser Office apps can vary. Some paste contexts strip formatting to avoid conflicts between source and destination styles.

✅  Fix: Try Ctrl+Shift+V instead of Ctrl+V - this opens a Paste Options dialog in many web apps where you can choose Keep Source Formatting. Alternatively, after pasting with Ctrl+V, look for the small Paste Options icon that appears at the end of the pasted text - click it to choose how the paste is applied. For text from a website, pasting into a plain text editor (like Notepad) first then copying again strips unwanted web formatting.

#8  I accidentally closed the browser tab mid-edit

😕  What happens: You are in the middle of editing a document, a tab crashes or you accidentally close the browser, and you panic that your work is gone.

🔍  Why: Auto-save is running continuously in the background on all cloud-stored files. Changes are saved every few seconds automatically.

✅  Fix: Reopen the file from OneDrive or SharePoint - your work is there, right up to the last few seconds before the tab closed. You do not need to do anything special. If the file was stored locally on your hard drive (not in OneDrive or SharePoint) and was not synced, recovery is not guaranteed - this is why saving everything to the cloud matters.

#9  An Excel formula is giving a wrong result or a different result than expected

😕  What happens: A formula that worked perfectly before gives a different answer, shows an error, or behaves unexpectedly in the browser.

🔍  Why: The vast majority of Excel formulas work identically in the browser. However, a small number of advanced functions - particularly some dynamic array functions, certain statistical functions, and any function that calls external data or VBA - may behave differently or not be supported in the web version.

✅  Fix: Check the formula bar for error indicators. For most everyday formulas (SUM, IF, VLOOKUP, COUNTIF, INDEX/MATCH, and so on) the browser version is identical. If a specific advanced formula is not working, search for the function name followed by "Excel for the web" to check its support status. For complex analytical work that pushes Excel's limits, consider whether the calculation can be restructured using supported functions.

💡  Tip: XLOOKUP, LET, and most modern dynamic array functions introduced in Excel 365 are fully supported in the web version. INDIRECT referencing external workbooks and a handful of legacy functions are the main exceptions.

#10  The file just spins and never loads

😕  What happens: You click a file in OneDrive or SharePoint and the browser shows a loading spinner that never resolves. Or the file opens but immediately shows an error.

🔍  Why: This is almost always a browser cache issue - your browser has stored a corrupted or outdated version of the page or session data. It can also be caused by a browser extension interfering with the Microsoft 365 domain.

✅  Fix: Try these in order: (1) Refresh the page with Ctrl+Shift+R (force refresh, bypasses cache). (2) Open a private/incognito window and try again - if it loads there, the issue is your browser cache or an extension. (3) Clear your full browser cache with Ctrl+Shift+Delete, select All time, check Cached images and files and Cookies, then close and reopen the browser. (4) Try a different browser entirely.

#11  I edited a file but now I can't find it

😕  What happens: You opened a file, made changes, closed the tab - and now you cannot remember which folder it was in or find it anywhere.

🔍  Why: If you opened the file from an email attachment or downloaded it to your Downloads folder and edited it there, the changes are saved locally - not in the cloud. If you opened it from OneDrive or SharePoint, it is saved and findable.

✅  Fix: Go to office.com and click the Recent files list on the home page - this shows everything you have recently opened or edited across OneDrive and SharePoint. If the file is not there, it was probably edited as a local download - check your Downloads folder. Going forward, always open files directly from OneDrive or SharePoint (not from email attachments) so they are always findable and automatically saved.

#12  I can see someone else's edits in real-time but then they disappear

😕  What happens: You are co-authoring a document and you can see your colleague's cursor or changes - but then they vanish, or your own changes seem to not appear on their screen.

🔍  Why: Real-time co-authoring sync occasionally lags, especially on slower connections or when one person's browser tab has been idle for a few minutes. The changes are not lost - they are just queued for sync.

✅  Fix: Wait a few seconds - the sync usually catches up on its own. If changes are still not appearing after 30 seconds, try refreshing the page with Ctrl+Shift+R. Both users should see the same content after a refresh. If one person sees a different version, one of you may have opened the file from a local cache - close and reopen from OneDrive or SharePoint to ensure you are on the live version.

Gotcha

30-second fix

#1  File opens read-only

Click Edit in the toolbar, or open from OneDrive/SharePoint - not from a download

#2  Macros don't work

E1 doesn't include VBA - ask IT about alternatives

#3  Ctrl+S doesn't save

Auto-save is on - look for Saved in the title bar

#4  Browser Ctrl+P breaks layout

Use File → Print inside the Office web app instead

#5  Custom fonts missing

Use standard fonts - upload font-embedded PDF for sharing

#6  File keeps opening in read-only after editing

Someone else has it open, or it needs check-out - see who has it open

#7  Paste drops all formatting

Use Ctrl+Shift+V or the Paste Options button for formatted paste

#8  Browser closes tab mid-work

Auto-save protects you - reopen from OneDrive, your work is there

#9  Excel formula behaves differently

Some advanced functions differ - check the browser formula bar for errors

#10  File won't load / spins forever

Clear browser cache → Ctrl+Shift+Delete → try private window

#11  Can't find the file after editing

Always open from OneDrive/SharePoint - check Recent in office.com

#12  Co-author edits not appearing

Pull to refresh, or close and reopen - real-time sync occasionally lags

💡  The one thing that solves most browser editing issues:

Open a private/incognito window (Ctrl+Shift+N in Edge or Chrome) and try the task again. If it works in private mode, the issue is your browser cache or an extension - clear your cache (Ctrl+Shift+Delete → All time) and you are done. This single step resolves the majority of "it's just not working" browser editing complaints.

🛟  Still stuck?

Contact the IT Help Desk. Describe what you were trying to do, which browser you are using, and what happened instead.