trioscapes.blogg.se - Office 2010 excel files open blank

#Office 2010 excel files open blank how to
#Office 2010 excel files open blank windows

I finally fixed it by going to Options -> Add-Ins -> Manage (Go…) and I saw that file had been created as an add in. “When I moved the file to a different folder, it wouldn’t open but I would get an error every time I opened Excel saying that if couldn’t find that file. She discovered that her unwanted file had been installed as an add-in.

#Office 2010 excel files open blank windows

In Windows Explorer, go to those folders, and remove the unwanted files, to prevent them from opening automatically when Excel starts.

C:Documents and Settings User nameApplication DataMicrosoftExcelXLSTART.

C:Program FilesMicrosoft OfficeOffice14XLSTART (for Excel 2010).

C:Program FilesMicrosoft OfficeOffice12XLSTART (for Excel 2007).

If there was nothing listed in the Startup box, the unwanted files might have been accidentally saved to one of the XLSTART folders.

Click OK, to close the Excel Options dialog box.

Clear the folder information from that box (or go to that folder and remove the unwanted files).

In the box for ‘At startup, open all files in’, you might see the name of a folder, and its path.

Click the Advanced category, and scroll down to the General section.

Click the Office Button, then click Excel Options (In Excel 2010, click the File tab, then click Options).

To stop files that automatically open in Excel 2007 and Excel 2010, you can remove a folder name in the Excel options:

#Office 2010 excel files open blank how to

Keep reading, to see where those files might be located, and how to stop them from opening. In that case, you can clean it manually and see if the attachment is opened correctly now.Do unwanted files open automatically when Excel starts? Perhaps something changed in your computer, and Excel files are opening automatically, and you want to get rid of them. Under certain conditions, this Secure Temp folder is not always cleaned correctly. The Secure Temp folder is the folder that Outlook uses to (temporarily) store attachments to that are being opened directly from within Outlook. Clear Outlook’s Secure Temp folderĪnother possible cause that Excel attachments are not opening correctly or with an error is because of other Excel files or templates in Outlook’s Secure Temp folder. When the option to ignore other applications is set,Īttachments will not open in Excel. When you now double click on the attachment, it should open as expected. Office logo (left top)-> Excel Options-> section Advanced-> option group: General-> option: Ignore other applications that use Dynamic Data Exchange (DDE)įile-> Options-> section Advanced-> option group: General-> option: Ignore other applications that use Dynamic Data Exchange (DDE)Īfter setting this option, close Excel. Tools-> Options…-> tab General-> option: Ignore other applications To disable this option you can do the following When the option is enabled, you can only open Excel attachments from within Excel itself. This is an option that is disabled by default but can be enabled to isolate the Excel working environment. The most common cause is that Excel has been configured to ignore other applications. Excel is set to ignore other applications This often happens when Excel is set to ignore other applications or when Outlook’s Secure Temp folder is “full”. When I double click on an Excel attachment, Excel opens but it doesn't open the spreadsheet or I get an error.