Skip to main content

Excel file opens up with blank screen in Excel

I have been asked to help a user with her Excel issue. At first, I thought I may have to write some Excel formula. But I was wrong. When I called her, she explained to me that she was unable to open certain Excel spread sheets. She said that whenever she opens these files, Excel opens with blank window.

I thought let me check it myself. Hence, I logged in to her PC remotely and tried to access same files. Yes, Excel window comes up but it does not show any data. User claimed that she had accessed file couple of hours back. Other users can open same files on their PCs without any issues.

I asked her to press CTRL + F10 key together while the file is open in Excel. Issue is resolved. It is a shortcut key to maximize or restore the selected workbook window. Now, she is able to view all files. I would suggest trying some other steps also, they are mentioned below:

  • Check if Excel has been setup as Run as Administrator.
  • Check the box “Run as administrator” on Excel shortcut.
  • Load Excel file. Go to View, select Full Screen. If you can see the file properly, close and restart it same way.


I hope you will find this article very useful.

Comments

  1. Chris Slater3 December 2015 at 13:38

    How do I get admin password?

    ReplyDelete
    Replies
    1. TechieTalks Team6 January 2016 at 12:06

      Hi Chris,

      If it is your work machine, please contact your IT team.

      TechieTalks Team

      Delete
    2. Chris Slater8 January 2016 at 21:33

      I am the IT guy here. I thought this was a site that could help me. Is this question to hard?

      Delete
  2. John Vitchmark31 December 2015 at 11:04

    Hi, I stumbled upon your blog as it references Microsoft Excel.

    I'm 58 years old and i've just purchased Microsoft Office for my first computer and am eager to learn how to make spreadsheets to help manage my taxes.

    My problem is, Every time i open excel it's a blank spreadsheet. How can i make it so i don't have to make a new spreadsheet every time?.

    ReplyDelete

Post a Comment

Popular posts from this blog

Windows 10 phone: This device has been locked for security reasons. Connect your device to a power source for at least two hours, then restart it to try again.

Hi All, this is my very first post on Windows 10 phone. I have a Windows 10 phone. Today, I saw following error message on phone. It didn’t allow me to unlock my phone using 4 digit pin I had set. The “Emergency calls” was the only option available to me. Error: This device has been locked for security reasons. Connect your device to a power source for at least two hours, then restart it to try again. I tried performing soft reboot but it didn’t fix. After doing a bit of research, I found a solution. Make sure that your phone is connected to Internet during this process. To fix this issue, follow these steps: Launch https://account.microsoft.com/devices on a web browser on another PC/Tablet or a smart phone Login using your Microsoft account (it is the same account you’ve used to configure your phone). Once you’ve logged in, Select your phone. On the next page, click on Lock button. A box will appear asking to enter 6 digit pin , a number where you can be reached (op
13 comments
Read more

Fixed: HTC One M8 USB driver doesn’t recognized by Windows 10

Hi friends, recently I upgraded my Windows 7 OS to Windows 10 on my laptop. Everything was working fine until I plugged my HTC One M8 (Android) phone to laptop using USB cable. A message box appeared stating that it could not detect the USB device. I never had any problem when I was using Windows 7. I used to plug my phone to PC using USB cable and access phone storage as USB drive. I typed my query in google and most of the articles suggested that I should installed HTC Sync Manager and then connect my phone. Well, I installed the required application but it did not resolve the issue. Hence, I removed it. This is my 3 rd HTC phone and I started to find out how I can enable USB debugging mode on my phone. This option is hidden by default. To enable this option, follow these steps:  Go to Settings \ About Select Software Information Click on More  option Now, tap on Build number  option six times in a row. A message will be shown saying “ You are now a developer! ” Go
9 comments
Read more

Virtual USB port is missing on Windows 7

Hi All, it has been a long time since I have posted last blog. I was away for a while during Christmas time. Today, I am going to share information about how to get virtual USB port in drop down list while installing local printer (USB) on Windows 7, if it’s not available by default. I followed below steps to add virtual USB port to add USB printer to Windows 7 PC.           Click on Start . Go to Devices and Printers .           Click on Add Printer .           Select Add a local Printer           In Choose a printer port box, select Create a new port option.           From the drop down list, choose Local port and click on Next button.           Port Name dialog box will appear. Type port name USB001 , click on OK           In the step, choose appropriate printer driver from list or provide a driver disk to complete printer driver installation process. I hope you may find this very useful. Disclaimer: www.TechieTalks.co.uk does not conceal the possibility of
8 comments
Read more