#1
|
|||
|
|||
Opening a file in Excel
I understand at this is probably a very stupid and most likely obvious question. However I am not by any means a Excel pro.
I recently upgraded to 2013 and when trying to open a previously saved .xls file instead of opening the selected file it only takes me to the screen that requires me to browse for the file. On older version I only needed to find the file and open it. Has this changed or am I just missing a setting somewhere? I really appreciate any help with this problem. |
#2
|
|||
|
|||
If I understand correctly, you are trying to open a file by directly clicking on its icon and when you do, Excel takes you to the open File dialog. Is that correct?
I have 2010 and have never had any issue like this. What happens if you open the file and save it as a .xlsx file? |
#3
|
|||
|
|||
Most of the files I am opening are Excel macro-enabled workbook files
|
#4
|
|||
|
|||
A .xls is not an Excel macro-enabled sheet extension. It is the extension used for Excel 2007-2003 files which, if I recall correctly, could contain macros. This may be what is confusing Excel.
What happens if you save the .xls file as .xlsm (macro-enabled extension)? |
#5
|
|||
|
|||
What if you right click on the file, select "Open with" and in the window with choices, select Excel? There should be a box you can check mark where it asks you you if you want to set the program to always open these type of files with that program.
Once the file opens, You can use Save As to save it as an Excel .xlsm type. |
#6
|
|||
|
|||
Tried that. It is actually doing the same thing with .xlsm files. It just opens a Excel window and I have to go browse for the file to open it.
|
#7
|
|||
|
|||
I did notice that the option it gives me to open with is "Excel Desktop". Not sure if that makes a difference or not.
|
#8
|
|||
|
|||
Go ahead and checkmark that.
|
#9
|
|||
|
|||
I did check mark that one and still doing the same thing. Is there a Microsoft tech support number that I can call?
|
#10
|
|||
|
|||
Excel Desktop? Are you using Excel Online too?
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Error message opening xlsb file in Excel 2008 for Mac | Bryce | Excel | 1 | 07-27-2014 09:35 AM |
'Another User' displaying when opening an excel file | ITSupportJourneyman | Excel | 1 | 01-28-2014 06:15 PM |
File Conversion Box-Opening PDF file | no1texan | Word | 1 | 10-24-2012 06:35 AM |
Opening the CSV file in the Excel has two different appearances! | Jamal NUMAN | Excel | 6 | 01-23-2012 12:55 PM |
File gets hanged up while opening in excel 2007 | nvsudheer | Excel | 6 | 06-11-2009 05:47 AM |