Forum Discussion
Why does my spreadsheet open "scrambled"?
Hi and thank you so much for your time on this. 🙂 I followed all of your suggestions and numbered my responses below to correspond with your numbered suggestions. I've also included some temporary solutions at the bottom, along with a follow-up question. 🙂
1. I updated Excel (even though it says it does it automatically) and it still isn't displaying correctly.
2. They were created in the current version (no compatibility mode) and are .xlsx
3. There's no option there to reset display settings. Do you know where else I can look for that option?
4. All of the printer settings that you mentioned are, and were, correct.
5. As mentioned, it is happening on other computers. Is there a way to determine if there's a problem with the file and if so, what the problem is? There are two of them that it's happening to and much was copied from one file to the other so I'm sure it's possible that I duplicated the problem from file to file.
6. I have one add-in but there's no option to disable or delete it, only to hide it. When I click the "Money in Excel" link it goes to a 404 page. Any idea what to do about that, how to delete it?
7. I followed the steps and repaired the installation. The problem is still there.
---------------------------
TEMPORARY SOLUTIONS:
Re the weird display issues: When I change the View from "Page Layout" to "Normal", then save and close the file, then reopen it, the odd display doesn't happen. The print issue is still there (the 6th row being cut off) but all the other weirdness doesn't happen. It was ChatGPT that suggested that possibility.
Re the 6th row displaying but getting cut off in printing: When I increase the font size in that field from 8 to 9, I can fit 5 rows of text and they all print, nothing gets cut off like the 6th line that displayed but didn't print when the font size was 8 instead of 9 (I hope that makes sense).
--------------------------
QUESTION:
Do I need to circle back to #5 and suspect that there's a problem with the files? If so, is there a way to determine if there is an issue with the file and what the issue is?
Thank you again so much for your help and time on this!! 🙂
It sounds like you are experiencing some formatting and display issues in your Excel spreadsheet. Here are some steps you can take to troubleshoot and potentially resolve these issues:
- Update Excel: Ensure that your Microsoft 365 subscription is up to date and that you have installed the latest updates for Excel. Sometimes, software updates include bug fixes and improvements that can address display and formatting issues.
- Check Compatibility Mode: If you are working with a spreadsheet created in an older version of Excel, it might be opening in Compatibility Mode, which can cause display inconsistencies. Try saving the file in the current Excel format (.xlsx) to ensure compatibility with the latest version.
- Reset Display Settings: Excel may sometimes encounter display glitches due to temporary issues with its display settings. Try resetting the display settings by going to "File" > "Options" > "Advanced" > Scroll down to the "Display" section > Click on "Reset Display" or "Reset All".
- Check Printer Settings: The issue with the 6th row of text being cut off during printing could be related to printer settings. Ensure that the print area is properly defined and that the page layout settings match your intended print layout. You can adjust these settings by going to the "Page Layout" tab and selecting "Print Area" or adjusting the print settings in the print preview window.
- Test on Different Computers: Since you mentioned that the issues occur on multiple computers, it's possible that the spreadsheet itself is corrupted or has compatibility issues with certain system configurations. Try opening the spreadsheet on a different computer to see if the issues persist. If the issues occur consistently across different computers, it may indicate a problem with the spreadsheet file.
- Check for Add-Ins: Sometimes, third-party add-ins or plugins can interfere with Excel's functionality and cause display issues. Try disabling any add-ins you have installed and see if the problem persists.
- Repair Office Installation: If none of the above steps resolve the issue, you can try repairing your Office installation. Access the Control Panel on your computer, navigate to "Programs" > "Programs and Features," find Microsoft Office 365, select it, and click on "Change" or "Repair" to initiate the repair process. Follow the on-screen instructions to complete the repair. The text and steps were 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.
Hi and thank you so much for your time on this. 🙂 I followed all of your suggestions and numbered my responses below to correspond with your numbered suggestions. I've also included some temporary solutions at the bottom, along with a follow-up question. 🙂
1. I updated Excel (even though it says it does it automatically) and it still isn't displaying correctly.
2. They were created in the current version (no compatibility mode) and are .xlsx
3. There's no option there to reset display settings. Do you know where else I can look for that option?
4. All of the printer settings that you mentioned are, and were, correct.
5. As mentioned, it is happening on other computers. Is there a way to determine if there's a problem with the file and if so, what the problem is? There are two of them that it's happening to and much was copied from one file to the other so I'm sure it's possible that I duplicated the problem from file to file.
6. I have one add-in but there's no option to disable or delete it, only to hide it. When I click the "Money in Excel" link it goes to a 404 page. Any idea what to do about that, how to delete it?
7. I followed the steps and repaired the installation. The problem is still there.
---------------------------
TEMPORARY SOLUTIONS:
Re the weird display issues: When I change the View from "Page Layout" to "Normal", then save and close the file, then reopen it, the odd display doesn't happen. The print issue is still there (the 6th row being cut off) but all the other weirdness doesn't happen. It was ChatGPT that suggested that possibility.
Re the 6th row displaying but getting cut off in printing: When I increase the font size in that field from 8 to 9, I can fit 5 rows of text and they all print, nothing gets cut off like the 6th line that displayed but didn't print when the font size was 8 instead of 9 (I hope that makes sense).
--------------------------
QUESTION:
Do I need to circle back to #5 and suspect that there's a problem with the files? If so, is there a way to determine if there is an issue with the file and what the issue is?
Thank you again so much for your help and time on this!! 🙂
