Over 1 million tech questions and answers.

Solved: Personal.XLSB in Excel 2010 does not open on starting Excel

Q: Solved: Personal.XLSB in Excel 2010 does not open on starting Excel

Problem in Excel 2010 [but revives a Closed TSG thread for Excel 2007]

The "Personal Macro Workbook" is a file called Personal.XLSB
The Personal.XLSB file is in the correct location /XLSTART/
The file properties option "Opens with Excel" is selected.
The file contains a (freshly re-made) macro.
(It also contained the same steps macro before it was deleted
and re-recorded during troubleshooting for this problem.)

When Excel is opened, the Personal.XLSB DOES NOT OPEN WITH it.

Because the Personal Macro Workbook does not open,
- existing macros do not function,
- nor can new macros be recorded

Same not-opening result, whether opened by clicking on
- Excel, in the Programs list or
- a desktop shortcut to a specific Excel file

However, the Personal.XLSB file can be opened and the macro made functional
by manually opening that file where it is stored in /XLSTART/

An unexplained workaround was identified in the closed thread.

*rename the Personal.XLSB to Personal.XLSA

I find this workaround effective.
The Personal.XLSA file opens with Excel and the macros are available.
But the file seems to be grayed out when viewed with Explorer in /XLSTART/

However, I do not like using workarounds, as they can cause trouble later.
I find that the "open with" setting was changed when the extension was changed
The setting is now "Opens with: Windows Shell Common"

I would appreciate an explanation how to make Personal.XLSB open as it should.
Or at least an explanation as to why the use of .XLSA is an acceptable alternative.

Thanks.

RELEVANCY SCORE 200
Preferred Solution: Solved: Personal.XLSB in Excel 2010 does not open on starting Excel

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Personal.XLSB in Excel 2010 does not open on starting Excel

Read other 16 answers
RELEVANCY SCORE 161.2

I am running Microsoft Office Professional Plus 2010 on Windows 7.

When I open Excel my personal.xlsb opens fine and my macros are available and I can create new macros. No problems.

BUT when I open any existing Excel file the pesronal.xlsb is not opened and therefore no macros and I cannot create new macros as I get the error "Personal Macro Workbook in the startup folder must stay open for recording." I have been trying things all night with no luck. Any suggestions would be greatly appreciated. I will list the things I have tried or checked with no success below:
In Options>Advanced Tab>General Section....the box for "Ignore other applications that use DDE" is NOT checked.
In Options>Trust Center>Trust Center Settings>Trusted Locations... I have C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART listed which is where my personal.xlsb is located
In Options>Trust Center>Trust Center Settings>Macro Settings ...Disable all macros with notification...selected and not selected neither way solves the issue.
In Options>Add-Ins>Manage: Disabled Items ...There are no disabled items.
I have deleted HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel in the registry editor
I have deleted C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB and then run excel to create a new personal file.
I have renamed C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB to PERSONAL.XLSA

Thank you in advance fo... Read more

A:PERSONAL.XLSB does not open when existing excel files are opened in Excel 2010

Read other 6 answers
RELEVANCY SCORE 159.2

I had the same problem which can be found in this thread: http://forums.techguy.org/business-applications/814855-excel-2007-personal-xlsb-wont.html

I have also solved it in the same way (Renaming my personal.xlsb file to personal.xlsa)

What wasn't discovered in the last thread is *why* this works. Any ideas?

My personal file has been starting up fine for years now. And the macros have run nearly every day. What could have caused this sudden change?

Sixhobbits
 

A:Excel Personal.XLSB does not open on starting up excel

I would guess that since .xlsa is not a recognized file type - and specifically is not .xlsb (which is a recognized file type) or .xlsm (also recognized and this was tried by the person in your link), 2007 treats .xlsa as simply .xls and loads it. This is merely a guess, however, but if it is true, it raises some interesting questions about security....
 

Read other 1 answers
RELEVANCY SCORE 129.2

My personal.xlsb file does not automatically open when excel starts. I have tried to delete and recreate the file. I know that Excel is going to the XLSTART folder and trying to open the files in there, because I changed the file extension and rec'd an error message when I restarted Excel. I have tried comparing Excel options/settings with others in my group but cannot find a difference. I have even deleted my file and used a coworker's file - which works for him (it contains the same universal macro's that we use for all of our files). But when I went to open excel, it still didn't open the personal.xlsb file.
 

A:Excel 2007 personal.xlsb won't automatically open

Read other 16 answers
RELEVANCY SCORE 123.2

I understand that to hide this worksheet I need to clicke View and then hide, then Save, but excel never asks me whether or not I want to save my worksheet when I exit so I'm guessing that's why this setting won't take.

I did this successfully on a previous laptop, but it is toast due to malware. Not sure why it should be a problem on this new laptop, unless the previous user (it was issued a work, and not brand new) did something to it, alhtough regular workbooks ask if I want to save changes so why it doesn't ask when there's just personal.xlsb I don't understand.

Any suggestions?

Thanks,

Ann
 

A:Solved: Excel: personal.xlsb--can't hide it

Read other 8 answers
RELEVANCY SCORE 123.2

I am trying to create a Personal.xlsb workbook within Excel 2007. I have the workbook created, placed in the XLStart folder, and hidden.

When I double-click on the Excel icon, a new workbook does not open. I can see the menu/command options, but there is not a spreadsheet.

Can anyone tell me what I am doing wrong?
 

A:Solved: Excel 2007 - Personal.xlsb

I have the new workbook working properly with the Personal.xlsb workbook partially.

When I open a blank workbook, and when ready close the workbook the personal workbook remains open. I have to then close the personal workbook. I know there is a way to close the personal workbook at the same time as the blank workbook.

Could someone point me in the right direction?
 

Read other 2 answers
RELEVANCY SCORE 120.4

I understand in excel 2007 -- when you build a macro and save it to a personal workbook it saves the file in the xlstart menu and automatically opens behind the scenes when you open an Excel workbook---- My problem is when I build a macro and it asks if I want to save changes to the personal,xlsb file if I click on yes -- from than on, when I open Microsoft excel the standard blank sheet one does not open but the personal.xlsb which is supposed to open but behind the scene. Any suggestions... J.T.
 

A:Solved: issue with excel 2007 personal.xlsb file

I don't know 2007. But in previous versions you have to hide personal.xls, then close Excel (it'll probably prompt you to save), then re-run Excel & it should stay hidden.

HTH
 

Read other 2 answers
RELEVANCY SCORE 112.8

Hi,

I am working with a number of macro's used to process a pledger each month. However recently the Macros stored in the Personal.XLSB file do not appear when I go run them. I am unhiding all workbooks and even when I load the macro's from the Personal.XLSB file they do not appear.

I am using operating system Windows 7 and MS office 2010 Professional

To resolve the problem I am restarting the computer at which point the Macro's reappear however this is not the most effective solution.

Can anyone help find a better solution

Many thanks

Chris
 

A:EXCEL Personal.XLSB Macro's Dissapear

Welcome to TSG. Hope you get some help and take the opportunity to help others when you can.

I haven't experience the problem you describe but in MS Access I've found strange macro behavior in Office 2010 if the 'Trust Setttings' aren't set. You need to 'allow all macros' and trust the location of the spreadsheet.

Hope this helps.
 

Read other 1 answers
RELEVANCY SCORE 106.8

Hello!

I need to convert xlsx-files to xlsb-files. I've found some tools on the internet, which are able to do that, but only if all the xlsx-files are in one folder.

My folder topology looks like this:
main folder -> containing 44 folders -> each of them containing 1-3 specific folders -> where each of those specific folders contain 1 specific folder -> which contains the xlsx-files (about 10-30 files) which need to be converted into xlsb-files.

In short: there are about 1800 xlsx-files widespread amongst some folders and subfolders. And because there are so many folders and files, it would be a horror to do this manually.

The format of the folders is the same for all of them (just timestamps and numbering differs).

A:Batch processing (xlsx to xlsb) in Excel 2010

What tools have you found? I'm having trouble locating any.

Read other 9 answers
RELEVANCY SCORE 104

Excel will not open my personal.xlsb file but if i create a copy entitled "Copy of Personal.xlsb" it will be recognized. This is quite irritating.
 

A:Personal Xlsb wont open but "Copy of Personal.xlsb" will

So I assume you tried renaming the original Personal.xlsb file and creating a new one?

You should also be able to go to the Excel startup directory and manually open the file in order to save/export any existing code modules to a new workbook.

Rollin
 

Read other 3 answers
RELEVANCY SCORE 100

I知 running Excel 2010 on both my work & home computers. I have around 30 macros stored in my Personal.xlsb file. Occasionally, I値l modify a macro at work and, to be able to have all my work macros available to me on my home PC, I値l attach the updated Personal.xlsb file to an email to myself at home. I then drag the file to the desktop, open it and attempt to save it in the appropriate XLSTART folder on my home PC.
At work, I知 using Office with Windows XP Professional; at home, I知 using it with Windows 7 Home edition.
The Problem: When I attempt to 壮ave the new macro file on my personal PC, or indeed if I actually modify a macro on my personal PC and attempt to save it (done via VBA), I知 prevented from doing so for some security reason and get a message that I should save it under a different name and move it to the XLSTART folder. Normally, when I do this (though it痴 sort of a pain because of 7痴 file structure), I have no problems afterward. Most recently, however, Excel launches with Personal.xlsb 繕nhidden. I致e tried several things to get it to remain hidden without success.
Any ideas what痴 wrong? How to overcome? Or for that matter, why I can't save the modified file directly to \XLSTART?
Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM)2 Quad CPU Q8200 @ 2.33GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 4
RAM: 8191 Mb
G... Read more

A:Solved: Personal.xlsb not hidden on open/can't save

Pls use explorer to copy and paste the file, not in VBA when excel is open.
Cos when excel is open Personal.xls is in use.
Also check that XLSTART is trusted in Trusted Location.
 

Read other 2 answers
RELEVANCY SCORE 94.8

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: AMD A6-4400M APU with Radeon(tm) HD Graphics, AMD64 Family 21 Model 16 Stepping 1
Processor Count: 2
RAM: 7650 Mb
Graphics Card: AMD Radeon HD 7670M, -2048 Mb
Hard Drives: C: Total - 931724 MB, Free - 865841 MB; D: Total - 21840 MB, Free - 2343 MB;
Motherboard: Hewlett-Packard, 18A7
Antivirus: Norton Internet Security, Updated and Enabled

I am unable to open a password protected Excel 2010 file in Excel 2007.

When attempting to open this file nothing happens but on clicking the office button the New and Open options are available but all the other options are greyed out.

Using the open option has no effect on this file whatsoever.

I would be grateful for any suggestions.

Regards

Flynne
 

A:Excel 2010 file will not open in excel 2007

Does is need to be saved in a different format. Wasn't there a change in the default around that time??
 

Read other 1 answers
RELEVANCY SCORE 90.4

I am using microsoft office 2010 and windows 7.

I have set up excel to open files from a specific folder. When I click open it only shows files such as *.xls etc.

How can I setup to open all files (*.*) ?

Thank you very much
 

A:Solved: Excel 2010 - How to set open to open ALL files

Read other 12 answers
RELEVANCY SCORE 89.2

We recently migrated from Office 2003 to Office 2010.

Just to give some background, (and I dont' know if this is relevant to this error), the Office 2003 excel did not accurately show the correct file paths where files were linked. It would show something in the C drive.

The issue I am concerned about today is this: when some users close files in 2010 (files were created in they sometimes get the error below:

'"The name ABE2, either conflicts with a valid range reference or is invalid for Excel. This name has been replaced with _ABE2"

Can someone assist me with this? I need to stop it from appearing and I am not sure how.
 

A:Solved: Excel 2010 v Excel 2003 Error Valid Range

Read other 14 answers
RELEVANCY SCORE 89.2

I've searched for issues regarding non-working VBA code written for Excel 2010 and compatibility wit Excel 2011 for MAC.
I am currently using Addin (*.xlam) files that hold all the necessary code to process multiple files without needing to use the PERSONAL.XLSB and as eliminating the need to copy VBA code to every file that requires.
This works perfectly with all the Windows Office versions.
Today a colleague want's to run this same file on a MAC book with Office 2011.
The moment he opens the Addin het gets an error that a library cannot be found, understandable, but the Tools Reference in the VBA project is also greyed out so I cannot even try setting any reference.
Does anyone have any experience with this or is this something that needs a complete new approach when it regards Office on the MAC?

I hope somebody can help
 

A:Solved: Excel 2010 xlam file not working with Excel 2011 for MAC

Read other 6 answers
RELEVANCY SCORE 85.2

Running Windows Vista Premium Home Edition.

I have an Excel 2003 spreadsheet.that I originally created on Excel Office Professional Edition 2003. Also, have Excel 2007 Home and Student Edition installed. I uninstalled the Excel 2003 software, but now when I clik on this created Excel 2003 spreadsheet with Excel 2003 it will not open. It says there is an invalid path. I reinstalled Excel 2003 and it opens. I tried to save this as an .xlsx extension and then uninstalled Excel 2003. It wouldn't open. So something is occurring here. On other Excel 2003 created spreadsheets, they open without issue.

Then I have a program with an .exe extension. It needs to open using Excel 2007. With both Excel 2003 and Excel 2007, it will not open. It freezes and then I get an error message saying it cannot open with another Excel other than 2007. If I right clik on the .exe program, there is no "Open with". I even tried opening a blank Excel 2007 spreadsheet and then cliking on "Open". but it is a bunch of gibberish. My IT person says you can't open the program that way, You have to launch it as an .exe program using Excel 2007.

Any ideas on what is going on? By the way, I have both Excel versions on my laptop running Windows XP and I do not have these issues at all.
 

A:Solved: Some Excel 2003 & Excel 2007 applications won't open on Windows Vista

Hi there,

If I said I was confused that'd be an understatement I think. You cannot open executable files (*.exe) with Excel. Recognized file types are things like .xls, .xla, (for 2007) .xlsx, .xlsb, .xlsm, etc. I don't know what your exe file is and I'm not sure I wanna know, but it certainly doesn't open in Excel. What is it exactly? If you don't know I wouldn't open it. Or if someone told you to open it with Excel then it's probably a virus. Unless I'm missing something here.

With the file in question which won't open, assuming it's not this strange and unknown exe file you're talking about, sounds like the file may have been corrupted. Does it open on any other machine? And if you uninstall Excel 2003, did you re-install 2007? It seems strange. I would try cleaning out your application and reinstalling 2007 fresh. You can't install 2003, then 2007, then take off 2003 and put it back on, you're gonna get things screwed up. I bet your registry doesn't know which way to turn here. Some good info on it can be found here...

http://officearticles.com/misc/best_install_procedures_for_microsoft_office.htm

Also, I would highly recommend you completely uninstall all versions, and I'm talking a deep cleaning, then reinstall. For that deep cleaning, take a look at this article (which I'd highly recommend you do) and then reinstall...

http://officearticles.com/misc/remove_microsoft_office_from_your_pc... Read more

Read other 2 answers
RELEVANCY SCORE 84

Created a worksheet with formulas, in Excel 97, and saved it on floppy and hard drive. Can open worksheet from floppy and hard drive in Excel 97 but not Excel 2003. Formula cells become #NAME?

Sample of formula:
='C:\blp\api\dde\Blp.xla'!BLP(C190&" equity","ask",,,RTD("BLOOMBERG.RTD","","IZU+UV Equity","ASK"))

How can I resolve? Thanks.
 

A:Solved: Can't Open Excel 97 File in Excel 2003

Read other 7 answers
RELEVANCY SCORE 82.8

I need to copy only  all excel files xlsx , xls, xlsm,xlsb in my documents
path as below

C:\Users\user\Documents

to  path C:\Users\user\backupoffice    keeping the folder structure including subdirectories.

  Can this be done with robocopy I used both windows 8.1 and windows 7.

looking a code to do this

Can anyone assist

thanks

Read other answers
RELEVANCY SCORE 82

This is so very strange and I am stumped. The user had Office 2002. I uninstalled it, then installed Office 2010. When she clicks on the Excel icon (from the desktop, or from the all programs list, and even from the MS Office folder in Program files) a window pops up and it displays "the name of a document" and "file format is not valid". It is trying to open a Word document! She said this was occurring with the old Office version also. Once that window is closed Excel work fine. It's as if the Excel executable somehow became a shortcut for this Word document. She said that the document was deleted quite awhile ago.

Any help would be appreciated.
Thanks!
 

A:Excel 2010 tries to open .doc

Read other 7 answers
RELEVANCY SCORE 81.2

Couple of issues here.... help!

1) When I am in Gmail (email) and want to open a word doc or excel and try to open it by a click (internet explorer) it opens of the window that comes with the computer to "buy" or ... so I have to save on the desk top, open word or excel then open the document through the software.

2) When I am in Gmail (email) and want to open a word or excel document in (Chrome) it opens a little window which ask if I want to open, save or open/save and where to save it. If I press open another window opens and ask if I want to open it now.
How can I just click on the word or excel document from gmail or anywhere and it just open up instead of opening up the program to open within?

Thank you ahead of time!
 

Read other answers
RELEVANCY SCORE 81.2

Similar to your conversation string back in 2010, I have found the same problem: when exporting a .tsv file from Oracle (having already associated it with Excel through the Default Programs section of Windows 7), my computer thinks about it, then does nothing. I was able to do this seamlessly with Excel 2007. Any updates since 2010 on this?
 

A:Excel 2010 Does not open .tsv files

Hi, welcome to the forum.
Nothing's changed, 2007 or 2010, all the same.
Did you reset your association with Excel 2010 after you installed it?
 

Read other 1 answers
RELEVANCY SCORE 81.2

I am having a problem opening a .tsv file with office 2010 running windows 7 on multiple machines.

Here is the situation:
I am exporting a document from Oracle. The file is in the .tsv format. It prompts me to open or save. Of course if I try either it tells me I need to set a default program to open the file. I search for the Excel program from my Office/Office14 file. Click Ok and then when I double click on the file to open it nothing happens.
I have tried manually setting the default association and it will never open the file.
This works flawlessly on a windows xp machine running Office 2007 or before. 2010 Excel is the only problem we have had.
I have only been able to trick it into using Excel so far. When it asks me to save the document I chose a location and type .xls after the file name. When I open it there is an error message and I have to resave it, but then it works.

If it was me I wouldnt worry about this, but I have 100 users that may start having this issue and they will not want to deal with it.

Any help would be appreciated.

Thank you
 

A:Excel 2010 will not open .tsv files

Read other 15 answers
RELEVANCY SCORE 80

I am having problems trying to open Excel files by double clicking them for some strange reason.

If I create an Excel file then save it for some bizzare reason it won't then open again by double clicking it. I have tried to go into the choose default programs but I can't find Excel 2010 anywhere, so what I done was to create an Excel short cut on the desktop and then tried to use that as the default program but I get the following message:

C:\Users\********\Documents\*******\********\****.xlsx is not a vaild Win32 application.

(I have used the *'s instead of the proper path)

A:Can't open Excel 2010 files for some reason?

  
Quote: Originally Posted by BomberAF


I am having problems trying to open Excel files by double clicking them for some strange reason.

If I create an Excel file then save it for some bizzare reason it won't then open again by double clicking it. I have tried to go into the choose default programs but I can't find Excel 2010 anywhere, so what I done was to create an Excel short cut on the desktop and then tried to use that as the default program but I get the following message:

C:\Users\********\Documents\*******\********\****.xlsx is not a vaild Win32 application.

(I have used the *'s instead of the proper path)


Have you tried right clicking on an xlsx file, choose Open With, and browse to the excel.exe? I don't have 2010, but mine is in

C:\program files (x86)\Microsoft Office\OFFICE11\EXCEL.exe

Choose the exe and click always use the selected program...

A Guy

Read other 2 answers
RELEVANCY SCORE 80

Hi Guys,

this issue only happens to 1/2 dozen of my PC out of 150, i don't what cause it and how to solve it. had tried /regserver and adding ExtensionHardening registry to each of the PC registry to no avail. tried the open with option, redirect it to excel.exe in office14, checked the always use this program check box, yet no avail. tried repairing...no avail too.

these 1/2 dozen PC, can't open any excel extension just by 2x clicking the file. they're all using office2010. OS: XP SP3.

any lead someone?
 

A:Excel 2010 can't automatically open xls and xlsx

Read other 7 answers
RELEVANCY SCORE 80

I was reading this past thread and am having the same problem with a few machines in the office. They are all running Office 2010 on Windows 7 and I can't get the file associations correct. The newer file extenions are fine but the xls and xlsx files will not automatically open when double clicked. They WILL open if you open Excel and then go to the file, open commands. The new 2010 files will open automatically when double clicked. Files are all saved on the desktop or same folder with different results. Does anyone know of a fix to this? I have done all of the normal fixes, repaired the installation, tried manually open with and checked the always open with box, went to options, advanced, and the "Ignore other applications that use DDE" was not checked. The ONLY thing I can think of is that some of these users are using Microsoft Project 2003. But I did do a full uninstall on Office 2003, fully uninstalled Office 2010 and re-installed Office 2010 and am still not able to have the users double click to open files. Any other ideas? (Again, only happening on a few machines, other machines running Office 2010 on Windows 7 are fine)
 

Read other answers
RELEVANCY SCORE 79.6

Most of my Excel files open fine with a doubleclick from Windows Explorer. I have two XLSX files however, that "try" to open when I single click. They open to a blank, grey screen - essentially they open Excel, but the file does not open. (I do see a quick flash of tabs at the bottom indicating the file is starting to open or opens and then terminates immediately).

The problem is clearly not a "tiled window" or "window offscreen" problem - there is no file open. All the Excel functions are greyed out. If I go to File-->Options, i just get a blank grey screen. If I go to file --> open, I can then open any file.

It seems that these two files have some kind of trigger property that starts Excel with one-click, but I can't find how to change that property. None of my other XLSX files act this way.

UPDATE: Further experimentation reveals that this problem is somehow linked to password protection. I copied all the tabs to a new sheet and saved as XLSX. This sheet works normally, i.e. I can click on it once to highlight it and it does not open Excel. I double click and it opens. But once I password protect it, the behaviour changes to that described above.

A:Excel 2010 - Excel Opens Blank on One Click of File

Do you have the "preview pane" on? if so, turn it off and you should be able to view the password protected documents properly.

Read other 1 answers
RELEVANCY SCORE 79.6

Hi guys,

Since a day or two I?m having the following issue when I close an excel file (extension xlam).

I write my own addin files and have been using them for many, many years.

I?ve read that this seems to be a bug with Excel 2010 but the strange thing is why now and not before?

The addin is not installed, I run it when I need it, it contains the necessary xlm code with custom ribbons and all the necessary buttons, you name it, it just works as it should.

I have one button that either close the addin or quits Excel altogether

The VBA project?s properties are set to non-visible and password protected.

Now I get the dialog prompt to enter the VBE password. If I enter the password or press cancel, all I get is that Excel has encountered a problem and will shutdown.

OS: Windows 10 64-bit, Office 2010 and everything has been running fine with Windows 01 and before that with Windows 7

VBA Editor window is not maximized (as I read on several posts), and when I remove the password and save it and then reopen the vbe editor does not show up anymore when closing.

If I run the same macro directly, not using the menu button, the same thing happens. It seems like it?s trying to access the VBA properties, but I have not added any code to do that.

Very strange and especially I do not like thing I do not understand, no changes made and I do not address the VBE components in any way.

Any ideas?
P.S. I cannot upload the file but the thing is that it just started, all at on... Read more

Read other answers
RELEVANCY SCORE 79.2

Every time I open an existing document in Excel it also opens a blank document (Book1) in a separate Excel session along with the document I am requesting to be opened. The same is happening with Word.

I am under Win7 Home Premium and Office 2007 Professional.

I have seen that someone had same problem, but I don't have any visio file in xlstart file.....

Do you have a fix for this problem?

Thanks, kind regards

Rey
 

A:Excel and Word 2010 open a blank page

Click on Start > Search programs and files type the following:
winword /r
(This will reset the default setting for Word 2007)

Next Click on Start > Search programs and files type the following:
excel /o
(This will reset the default setting for Excel 2007)
If the issue still persists, search "excel opening blank file" in Google and out of many search results, click on the one from answers.microsoft.com and follow the steps mentioned there.
 

Read other 1 answers
RELEVANCY SCORE 79.2

I was searching for a way to open multiple windows in Excel every time I double clicked on an Xls or Xlsx file. I looked and found some solutions for 2007 and prior versions however I did not find any solutions for the Win7 Excel 2010 environment.

(I did find a way to do it by changing a fix for Win7 Excel 2007. Please let me know if it helps or if there is a different/better way to fix.)

Works for
Excel 2010 & Win7 (could work for 07 not tested)
------------------------------------------------------------------------
Open Registry Editor ver 6.1

-Go to Branch:
HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command

(Note: it doesn't matter what is listed under default)

-Change the value command and under data remove /dde (or /e) and add after existing string the following code below

/p "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" /e "%1"

(Note: /p switch will ignore the (default) open settings)

-Go to Branch:
HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec

-Rename ddeexec2

(compare to screen shot)
Excel 2010 Win7 Registry.jpg

Hope that helps users with Win7 Excel 2010.
-Kenton

A:Excel 2010 Win7 Open Multiple Windows

-Similar solution to above as a .reg file: Copy the following into a .txt file, then rename as a .reg file and save. Run as an administrator. You will need to replace the <Hexidecimal value> with the value specific to your install. Easy way to do that is to export your current key value.
------------------------------------------------------------------------------------

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\""
"command"=hex(7):<Hexidecimal value>

[-HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec]
@="[open(\"%1\")]"

[-HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec\application]
@="Excel"

[-HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec\topic]
@="system"

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec2]
@="[open(\"%1\")]"

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec2\application]
@="Excel"

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec2\topic]
@="system"

[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\""
"command"=hex(7):<Hexidecimal value>

[-HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec]
@="[open(\"%1\")]"

[-HKEY_CLASSES_RO... Read more

Read other 9 answers
RELEVANCY SCORE 79.2

I have been getting the following errors in Excel 2010 for about 3 months and they are getting more frequent (I have Win 7 Pro):

(1) Errors were detected while saving 'C:\Users\username\Documents\filename.xlsx'.
Microsoft Excel may be able to save the file by removing or repairing some
features. To make the repairs in a new file, click Continue. To cancel saving the
file, click Cancel.
(2) Cannot open the Clipboard.
(3) An unexpected error has occurred. AutoRecover has been disabled for this session of Excel.
(4) Excel has stopped working.
(5) Freezes on print preview.

I have done the following:
- Tried Excel in safe mode.
- Uninstalled and Reinstalled Office 2010.
- Disabled all add-ins.
- Done an exhaustive search on the internet only to find that other people have one or more of these errors, but no solutions.
- Other Office 2010 apps work ok.

Nothing has worked. I知 barely able to get anything done! Please help, I知 dying here!
 

A:Excel 2010 ProblemsI have been getting the following errors in Excel 2010 for about 3

Read other 16 answers
RELEVANCY SCORE 79.2

Hi,

After a power outage a particularly important file gets the error "Excel cannot open the file.xlsx beacause the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. The file format has not changed. Is there a safe free program that can uncorrupt a file? I have tried Open and repair, changing the format, and using open office. Also tried using recova but the file was not lost.
 

A:Solved: Excel 2007 spreadsheet gets error "Excel cannot open the file .xlsx.." How ca

https://support.microsoft.com/en-us/kb/820741

and 5 ways are shown here http://www.wikihow.com/Recover-a-Corrupt-Excel-File
 

Read other 2 answers
RELEVANCY SCORE 78.8

Hi

Does anyone know how to change the password for a Excel 2010 spreadsheet?

We have one, we know the password, but need to change it as many people that shouldn't know it, does. But can't figure out how

We can't use Save As, as the spreadsheet is linked to other tables on the network. Just want to change the password that we already know, to a new one.

Looked here already, they just mention Save As:

https://support.office.com/en-US/ar...ions-EF163677-3195-40BA-885A-D50FA2BB6B68#bm4

https://askdrexel.drexel.edu/app/an...:-change-password-of-a-workbook-in-excel-2007

We're used to Office 2003, so this is a big jump at work for us

Thanks

eddie
 

A:How to change Excel 2010 password (when in the excel sheet)

We can't use Save As, as the spreadsheet is linked to other tables on the network.Click to expand...

Why not? You can save it with the exact-same filename, even with the Save As command. It's only from here you can choose the Tools drop-down, General Options, and then change the password from there.
 

Read other 1 answers
RELEVANCY SCORE 78.8

As part of updatting our computer equipment I was reassigned from a Dualcore Windows XP Sp2 with Office 2007 to a new Quadcore Windows XP Sp3 with Office 2010. Both with IE8.

The problem at hand is this particular Macro that is run monthly and creates 167 web querys, one at a time. This is why I made a macro. The webpage that I get my imformation from is http://www.systematics-int.co.uk/, which has a login page.

What I used to do in Excel was to first manually create a web query in such page in order to enter my login credentials, confirm that I entered the page, close the query wizard, and then proceed to run my macro. It worked, and still works, flawlessly in my previous PC but not so much in my new one, as all I get from the macro are a bunch of worksheets saying that I'm not logged in so I can't retrieve any information.

I hope I've been explicit enough as how it doesn't work. I really need this to work because my old PC is going to be formatted and my only option would be to do this manually.

If you need more info please ask, I don't think I've been clear enough as English is my second language.
 

A:Excel 2010 web query is not working as it did in Excel 2007

Could ik be that the symantec site has attached your login to a specic Ip address or machine name which now is changed because of your new system?
I don't really think it;s Office 2010.
Your system is new, another mac address, probably a new IP address, new computername.

All these seeminly irrelevant factors may be the reason it's now working, have you tried executing your macro step by step? Trubleshooting takes a lot of patience and time.

I hope this gives you some ideas to look at
 

Read other 2 answers
RELEVANCY SCORE 78.8

Hi,

I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!
 

A:COUNTIFS working in Excel 2013 but not in Excel 2010

It might be something to do with "<>cancelled"
 

Read other 1 answers
RELEVANCY SCORE 78.4

Hello

I have an issue with a user. OS is windows xp and office 2010. When she gets an excel attchement, it can only open in preview mode.

I have done:
1> deleted the the contents of Temporary internet file.
2>Deselected the proetected view (all 3 oxes have been deselected.)
3> "ignore other application that use DDE" is deselcted.

Still no change.

Any help is appreciated.

Thanks
 

A:Outlook 2010 will only open excel attachement in preview mode

Try saving the attachment to a folder or to the desktop, then open from there.
To save, right-click the attachment and choose Save on the context-menu.
 

Read other 3 answers
RELEVANCY SCORE 77.6

Hi,
I seem to be going against the tide with my query.
By default, when I open an Excel associated file by double clicking it in explorer, my Excel 2010 opens each file in a new program window. This is really annoying as I often want to consolidate data and copying and pasting is not as easy across multiple
program instances.
I've seen lots of threads of people who want to make there Excel open files in separate instances, for example:
http://social.technet.microsoft.com/Forums/en-US/office2010/thread/749983b3-ba7e-49d3-99bf-f67d70245046
http://forums.whirlpool.net.au/archive/850718
http://blog.whitesites.com/Force-Windows-7-to-open-excel-documents-in-separate-windows__634014706378053750_blog.htm
but no one trying to make them all open in the same window.
Can anyone help, perhaps without resorting to altering the registry?
Thanks,
 
Alex

A:Need to make Excel 2010 open files in the same instance of the program (Windows 7)

In Excel 2010 go to File\Options\Advanced and under Display uncheck "Show all windows in the Taskbar".

Read other 6 answers
RELEVANCY SCORE 77.6

Hey all,

I'm having an issue with the Xerox Workcentre 7120 and Excel 2010. I simply cannot print Excel files whatsoever. It tells me that the document has been sent to the printer, yet two minutes later it tells me that the print job has failed - no reason given, it just says in the Completed Jobs tab that it was cancelled. When looking at the Completed Jobs tab on the printer itself, it tells me that it was "Completed-Error" - basically meaning that nothing happened. I'm running Windows 7 64-bit.

I've tried many fixes, including restarting the PC, restarting the printer, restarting the print spooler, reinstalling Office 2010 completely, installing another driver for the printer, running a repair on Microsoft Office 2010, reinstalling the printer completely (it's a network printer) and dancing around the PC in complete frustration whilst chanting (the last one helps a lot, strangely enough).

The weirdest thing is that it's just an issue with Excel - Word, Office and other Office programs print fine with this specific printer. Does anyone have any suggestions? I've tried printing to another printer in another part of the office, and that works perfectly fine. It's just a hassle having to go through multiple doors and parts of the office to retrieve a simple document.
 

Read other answers
RELEVANCY SCORE 77.6

Hello,

I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns.

It's a cinch when drawing a table in MSWord (2003) so I cannot imagine why this should not be possible in Excel, but then I don't know everything

Thank you

A:Formatting Excel 2010, Excel 2003

If I understand your problem then it is quite simple. Assuming A1 has the "heading" then select thsi cell and all the other cells in row A which pertaim to the tanle and then "merge the cells" and centre the title. I forget how this is done in Excel 2003 but I do remember it being available on the screen on the Edit toolbar I think.

Cheers

Read other 5 answers
RELEVANCY SCORE 76

Hi! i need you help!.. I am unable to open or save files in the shared drive using Excel 2007 but i can open/save excel 2007 files saved in my local drive

The error message I get when i try to open is "Could not open...." followed by the path and excel name.

This is the error message i get when i try to save in the shared drive:

Microsoft office excel cannot acces the file". There are several possible reasons:

the file name or path does not exist
the file is being used by another program
the workbook you are trying to save has the same name as a currently open workbook

Please help
 

A:Unable to Open and Save Excel files in the shared drive using Excel 2007

Read other 15 answers
RELEVANCY SCORE 76

Ok this is a weird problem I ran into in the past with Word, and I'm having trouble finding information on it, because of the details involved.

What's happening is if i load up Excel and then goto file/open and load an excel document it comes up.

If I goto Start/Documents and try to load it from there Excel seems to hang, also if i Browse my computer and goto any excel file same thing happens, and of course it happens over a network share as well.

I didn't give it more then a minute or 2 to come up (We are talking small Excel files here nothing huge) On the last computer this happened on with Word, the documents would eventually come up, but it would take 5 minutes to load this way.

Anything I load withen Excel (Meaning I load excel and then goto File/Open, comes up instantly)

Windows knows how to handle the excel files and what program to load them with, I tried deleteing the (Is it called a mime?) entry in windows that tells excel how to handle the .XLS file, then held shift and Right clicked a .XLS file to re-enter it into Windows, just in case Windows wasn't opening it right but this had the same effect.
Any ideas?
Thanks
 

A:Can't open excel files by double clicking, HAS to load withen excel

Read other 9 answers
RELEVANCY SCORE 76

I have a friend who is suddenly experiencing an issue where they are no longer able to Open an Excel file through their Windows Explorer (e.g. when trying to open a Excel file from within their My Documents folder). After double clicking on the file, Excel opens and acts as if it is opening the file but then proceeds to show just a blank worksheet. The file does not appear to be corrupt since they can then go to File/Open from within Excel, locate the folder and then Open it without a problem.

Any suggestions? Any ideas would be greatly appreciated as to the cause and resolution for this.

Thank you greatly,

Mike
 

A:Excel 2000 - Unable to open Excel file thru Windows Explorer

Check this out: http://www.pcreview.co.uk/forums/thread-1781119.php
 

Read other 1 answers
RELEVANCY SCORE 75.6

I am using an ASP.NET 2.0 web application using the Interop assembly pointing to the Microsoft.Excel 12.0 COM to open and write to a spreadsheet.

I have set the permissions for the DCOM to allow NETWORK SERVICE to open the Excel application, but when I try to open the actual file I get Exception from HRESULT: 0x800A03EC.

I have changed the website directory permissions to allow NETWORK SERVICE full access to the folder and I still cannot open the file.

Thoughts?

Read other answers
RELEVANCY SCORE 74.8

Hi,

On a PC in our office, there are a number of Excel 97 files which have a problem.
I think they were originally created on a Windows NT, or possibly even Win3.1 machine, resided on a floppy and were eventually given to someone in our office to enter data.
The files are stored in the My Documents folder on a W95 machine.

These files can only be opened by starting Excel and using the Open command and locating them.
If I try to open them directly from the My Documents folder, I get a series of error mesgs, splitting the name of the file and path:

Cannot find file C:\My.xls
Cannot find file Documents.xls
Cannot find file \Cold.xls
Cannot find file Repairs.xls

and the file refuses to open.

If I save the file to disk and try running it from another PC, it says "file may be read only", which it is not.

The file contains no VB code and no add-ins are loaded.

I also tried copying all the data from the file into a new file. This worked until I moved the old file out of My Documents and renamed the new file "Cold Repairs", upon doing so, the same errors occurred again.

Any ideas?

Cheers,
Gram
 

A:Excel 97 file only opens from open Excel window. Help!

Read other 8 answers
RELEVANCY SCORE 74.8

I have a similar problem as the previous posting but my problem is with Excel not Word. When trying to open any Excel file I receive the message: "There was a problem sending the command to the program." The only way I can access an Excel file is to open "All Programs," choose "Microsoft Office" folder, choose "Microsoft Office Excel 2007" icon, choose "Open" folder, and double click on desired file.

My computer is a three month old custom unit built with Windows 7 Professional. I am using Microsoft Office Home and Student 2007. There have been no problems until this week.

Thanks for any help,

Wilks
 

Read other answers
RELEVANCY SCORE 74.8

I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The interesting thing is that if I try to open the same file that I have saved within the last year (before I got 2007) then I can do it? That is, I have a cache folder of files that I go get to do calculations then save in a new job folder. The ones in the new job folder will open (also 2003), but the ones in the original cache will not? I would truly appreciate any suggestions. Thank you.

A:Can't open 2003 Excel Files in Excel 2007?

Have you attempted to set them up in 'Compatibility Mode." Not sure if this will help, just hoping it will. I have been testing the new Microsoft Office 2010 Beta 64 bit, and have yet to have this problem, and like you I have a great deal of files in 2003 (never used 2007)'

I think you can still download MS Office 2010 beta from Microsoft's download site. Good Luck.

BTW, Welcome To The Seven Forums.

Read other 9 answers
RELEVANCY SCORE 74.8

Hey all,

I have come to you in a fit of desperation. My USB drive was stolen recently and my master Excel data file was lost, which contained all my compiled data from my most recent lab experiment.

Anyway, I have charts of all the important stuff in a word document. The data is there, I can hover on each data point and see the values, and the axes and chart are all accessible for editing.

My question is, how the heck do I extract that data back out of the chart into a table or Excel spreadsheet? There MUST be a way that is better than copying down each data point one at a time

Your help is greatly appreciated.
 

A:Excel chart in Word 2010: extract chart values? Lost Excel data file!!!! Help.

Hi welcome to the fourm.
I don't know it reverse engineering is possible.
Something like convert chart to table?

One thing you could try is copy the chart back to a new Excel file and see if more is possible there than in Word?

Like I said never needed this. Have you googled for something like Excel data reverse enginieering?
Maybe something come up.
 

Read other 1 answers