Over 1 million tech questions and answers.

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

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

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

RELEVANCY SCORE 200
Preferred Solution: Solved: Excel 2010 xlam file not working with Excel 2011 for MAC

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: Excel 2010 xlam file not working with Excel 2011 for MAC

Read other 6 answers
RELEVANCY SCORE 103.6

I found soultion to the following error:

"Excel cannot open the file '~$NitroPDF.xlam' because the file format or file extension is no valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

Please look at the follwimg site
http://wwwnitropdf.com/kb/article.aspx?id=10156

I am using Win XP & Nitro PDF prf. ver 5.5.2.5
 

A:Excel cannot open the file '~$NitroPDF.xlam'

Hi, welcome to the forum.
~$NitroPDF.xlam is a temporary file so you cannot open it.
It's Excel's temporary file which is created alongside the the Addin.
xlam is the extension for an excel addin file
 

Read other 2 answers
RELEVANCY SCORE 93.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 93.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 92.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 92.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 92.4

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 need to convert a routine used in a macro in a Excel 2010 spreadsheet so that it will also run in Excel 2010 (on a MAC0. I've added code to determine whether I'm on a PC or MAC, and have all macros running except for one that needs to open all files (containted in a single folder) that match a file name *string*.xls). The following code works on PC but not MAC; it fails on the Dir(FileSpec) step.

On Error GoTo prob_getting_workform:
Dim FileSpec As String
Dim j As Integer
Dim FileName As String
Dim FileList() As String
Dim FoundFiles As Integer
Dim CntF1 As Integer

' Specify path and file spec
FileSpec = new_extended_path & "*Al.xls"
FileName = Dir(FileSpec) ' **** FAILES HERE

' Was a file found?
CntF1 = 0
If FileName <> "" Then
FoundFiles = 1
ReDim Preserve FileList(1 To FoundFiles)
FileList(FoundFiles) = FileName
Windows(opened_file_nam).Activate 'select bill sheet
Range("P13").Select
ActiveCell = FileName ' save 1st file name in Col P13 of Billing master
CntF1 = CntF1 + 1
Else
MsgBox "No files were found that match " & FileSpec
Exit Sub
End If
' Get other filenames

Do
FileName = Dir
If FileName = "" Then Exit Do
FoundFiles = FoundFiles + 1
Windows(opened_file_nam).Activate 'select bill sheet
Range("P13").Offset(CntF1, 0).Select
ActiveCell = FileName ' save 1st file name in Col P13 of Billing master
CntF1 = CntF1 + 1 ' increment table in bil... Read more

Read other 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

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.
... Read more

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

Read other 16 answers
RELEVANCY SCORE 87.6

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
RELEVANCY SCORE 86.4

EMET 5.2 is causing Word, Excel 2010 and IE 8 to crash with a "Microsoft Excel has stopped working" error when we have ASR active for these applications.

Installed apps:
EMET 5.2
MS Office 2010 32 bit.
Blue Cielo Meridian 2011 SP1.

Blue Cielo Meridian 2011 SP1 has 2 services running that integrate with MS Office 2010, these are:
AMHookTray.exe (x64)
AMHookTrayU.exe (x86)

If I end the 32 bit (AMHookTrayU.exe) application in task manager then problem does not occur.
If I disable the ASR in Word or Excel then again the issue does not occur.

I have added AMHookTray.exe, AMHookTrayU.exe to the "Modules" but I still get the error.
Any suggestions would be welcomed.
Rob

Read other answers
RELEVANCY SCORE 86.4

Hi,
I'm working on an Excel project of mine and wanted to use VBA to create a Data Validation List in a merged cell.
The strange thing is that using VBA for some reason the list does not show as a drop down list but as a long string
The string is the 26 letters of the alphabet
A;B;C;D;E;F;G;H;I;J;K;L;M;N;O;P;Q;R;S;T;U;V;W;X;Y;Z
Click to expand...

Since I was doubting my own VBA code I decided to record a macro and added all the 26 letters of the alphabet
The resulting code:

Code:

Sub DVApply()
' DVApply Macro
Sheets("DataForm").Select
ActiveSheet.Unprotect
Range("B2:C2").Select
ActiveCell.SpecialCells(xlCellTypeSameValidation).Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="A;B;C;D;E;F;G;H;I;J;K;L;M;N;O;P;Q;R;S;T;U;V;W;X;Y;Z"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
Range("D5").Select
End Sub

Now here is the thing. The moment I record the macro the list shows up nicely as a dropdown list, but if I run the macro the new list will show up again a a single string and not in a list unless I open the Data Validation Dialog and click Apply and close it.
I&#... Read more

A:Solved: Excel (2010) Data Validation using VBA not working as expected

Whatever the problem is I wrote another routine and it works now.
I've thrown every range at it and it (still) works.
I'ts still strange why even the recorded macro does not work when you run it again afterwards.
Let it be, one more of Microsoft's deep secrets
At least this post had 15 views, but I'm marking it solved.
 

Read other 1 answers
RELEVANCY SCORE 86.4

I've got an issue / question that I cannot figure out why it happens.
I have attached a asample file to illustrate it.
There are three coloured cells.
The yellow colored cell has nothing, the green colred cell has Data Validation for a List and the blue colered cells has data validation for a whole number between 0 and 10

I added a ... BefodeDoubelClick action to display something, in this case a Message Box.

If the sheet is unprotected, the message box is displayed if one of the selected coloered cells is doubleclicked.

There are 2 buttons, one to pritect and one to un protect the sheet

However, If the sheet is protected, the cell with tha Data Validation List (green) will not trigger the action to display the message box.
If you select this cell and double click elsewhere on the sheet it will work.

Anybody know why this is?
Just curious.
 

A:Solved: Excel (2010) BeforeDoubleClick not working when sheet is protected

Guess unprotected sheet is like "Design mode".
Once you protect it, only "view mode" is possible for the drop down list.
 

Read other 2 answers
RELEVANCY SCORE 85.2

Hello all. Not a regular user of Excel; but do need help in creating something that would be useful to me and a few others at work. I suppose the best way of explaining what I'm after is by giving an example.

I have a directory C:\Users\Tekko\Desktop\Maintenance Project\Cape Nelson
In Cape Nelson are a number of folders named alpha beta charlie delta echo and foxtrot and so on.

I would like to have an excel template in "Cape Nelson" with a macro that when activated names the file as whatever folder name might be in say cell A1 and whatever ever date might be in cell B1. Eg charlie_15-mar-2013.xls
This then is saved in the relevant folder. So in the end I would end up with
C:\Users\Tekko\Desktop\Maintenance Project\Cape Nelson\charlie\charlie_15-mar-2013.xls

Also the macro script would ensure that the macro was disabled in the saved file.

Hoping this is achievable and look forward to replies.
 

A:Solved: Excel 2010 - Macro to name and save file to a specific folder

Read other 16 answers
RELEVANCY SCORE 84.8

Hi

I've recently had to get a new computer and decided to try a Mac. Everything works fine, however, I have excel files which I have transferred from my old Windows laptop which, when opened on the Mac, have not kept the colour formatting from the windows version. Is there anything I can try to see if the original colour formatting can be accessed or will I have to re-colour them all from the start?

Thanks for any help, advice, support in advance.

Wayne
 

A:Excel 2003 (Windows) to Excel 2011 (Mac) colour format issue

Hi Wayne, It's not the MAC, the issue is the fact that the newer versions of Office (also on MACS) have diffrente shading of colors.
The basic colors in Excel 2003 are not always the same.
I imagine that there is color formatting but that the shades are off, correct?

I think it will have to be hand-work, I don't know hoe Microsoft thinks about this but, well, compatability is an issue here

Maybe there's a setting somewhere that tells it to use the standaard (old version) settings, but I doubt that.

You'll need an inside-out Microsoft expert for this, I think.
 

Read other 1 answers
RELEVANCY SCORE 84.4

I'm hoping someone can help me with a small project I have.

Essentially, I want to create a spreadsheet using Microsoft Office Excel 2010 that would act as a time-sheet. It would have two columns - the first being a start time and the second being an end time.

So, a cell in the first column might say 8:30am, while a cell in the second column might say 5:30pm. What formula or method do I need to use to have a cell in the third column automatically tell me how many hours were spent in that time (9)?

Any help would be greatly appreciated.
 

A:Solved: Working Out Hours Between Start And End Time In Microsoft Office Excel 2010

Read other 14 answers
RELEVANCY SCORE 83.6

Hi there,

I am trying to use SQL.REQUEST to pull data from one excel file (a master data file) to another one, and I can't get it to work. I think I don't have the correct connection string specified.

I'm using Excel 2002 on Windows 2000.

The task is, I need to build dynamic queries based on other cells in the "output" spreadsheet, such as, get a count of all records in the master file where the date field is equal to [cell reference] and the ID field is equal to [another cell reference] and a third field is equal to [third cell reference]...
So that, if the values in those referenced cells change, the records that match (and get counted up) will be different.
Also, there will be at least 10 different queries (I do a sum on a field that is a time duration, an average on that same field in another, etc) in different places on the spreadsheet.

I was able to get a simple query to work in Microsoft Query if I used static values, ie, I typed them directly into the criteria... however, these need to by dynamic so that when the same spreadsheet (a report template) is "saved-as" and new values for the criteria are input, the queries don't have to be re-created.

So, using MS Query, I can connect to the master data file and get the correct result... but I believe what I really need to use is SQL.REQUEST, so I downloaded the ODBC add-in and installed that.
I just can't seem to figure out what my connection string argument needs to be.
Th... Read more

A:Solved: sql request in excel file, to another excel file - connection string?

Nevermind folks - I googled +excel +"connection string" for probably the 20th time in 4 days... I usually investigate all result about 7 pages deep before giving up, and this morning, all of a sudden a new result popped up right at the top:
http://www.connectionstrings.com/excel

at about the same time, my boyfriend finally took a look at it, and he came up with this result: http://www.devlist.com/ConnectionStringsPage.aspx

I used the syntax in this example
Code:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";
AND IT WORKS!
(I almost got up and danced, I was so happy)

Just thought I'd come back and post the solution, in case anyone else ends up finding this thread in the same position I was in.

Now how do I mark this thing solved?
 

Read other 1 answers
RELEVANCY SCORE 82.8

Firstly I am a beginner of beginners but I try to learn as much as I can.
I have put the following protection code into an Excel 2003 workbook and everything runs ok. I then opened the workbook in Excel 2007, and saved it as a .xlsm file. When I try to open the .xlsm file in Excel 2007, I get a vba Runtime error 13, "Type mismatch", and the code sticks at the first line below("If Worksheets...). I have tried everything that my limited knowledge allows, searched the web for 2 days, and still have no answers.
Any help would be greatly appreciated.

Private Sub Workbook_Open()
If Worksheets(28).[A51] > "" And Worksheets(28).[A50] = Worksheets(28).[A51] = False Then
MsgBox "Sorry, this program is not registered for this computer, please e-mail .......... for more info."
Application.DisplayAlerts = False
Application.Quit
End If
End Sub
My system specs are shown below.

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) i3 CPU M 380 @ 2.53GHz, Intel64 Family 6 Model 37 Stepping 5
Processor Count: 4
RAM: 2934 Mb
Graphics Card: Intel(R) HD Graphics, 1243 Mb
Hard Drives: C: Total - 290143 MB, Free - 172186 MB;
Motherboard: Dell Inc., 0WXY9J
Antivirus: avast! Antivirus, Updated and Enabled
 

A:Solved: Excel 2003 vba code not working in Excel 2007

Read other 16 answers
RELEVANCY SCORE 82

Using Excel 2011 for mac, a file that I have been using for several months, consists of one worksheet only.  When I open it today, the worksheet tab is there but no worksheet.
 
1. Not even a blank worksheet or gridlines
2. Unable to goto a cell location
3. Right click on worksheet tab to unhide, but 'unhide' is inactive
4. Tried to right click the tab and 'hide' but received error message that the worksheet must 'unhide' first (but see 3. above)
5. Print preview says that there is nothing to print, so then nothing to preview
6. I can view the contents of the file when  I 'Quick Look' from the finder/folder
7. I can view the copy of the file that is on my android phone and in my 'box' account, but if I download and open in excel 2011 - nada.
 
I'm stumped, it's like the worksheet only is minimized and needs to be maximized/restored; or the worksheet is hidden, but unhide opetion is not available.
 
Suggestions?  Thank you

Read other answers
RELEVANCY SCORE 82

A macro I wrote in VBA for Excel 2004 won't run in Excel 2011 (alas...). Upon opening the spreadsheet an "on open" routine runs, and bombs out on the following command:
Code:
Set cmdbar = Application.CommandBars.Add _
(Name:="Sort", _
Position:=msoBarTop, _
MenuBar:=False, _
temporary:=True) 'msobartop docks the menu at the top

Does anyone know if the VBA structure ("CommandBars.Add") has been removed or altered?

Is there another way to accomplish the same thing in 2011? I want to create a custom command bar (I populate it later in the module).
 

Read other answers
RELEVANCY SCORE 81.6

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 81.6

Hi

I am looking to create some code to move a sheet from one file to a new excel file. SO the code needs to open a new excel workbook and place the required sheet in the resultant new file.

I have managed to do this with an existing file "Moved Pivot" per the code below. This is ok but other people will be using my sheet so the location needs to be chosen by them. A new file seems to be the only solution?

Workbooks.Open Filename:="C:\desktop\Optegra Installer\Moved Pivot.xls"

Dim oTargetSheet As Worksheet
Set oTargetSheet = Workbooks("Moved Pivot.xls").Worksheets(1)
Call ThisWorkbook.Worksheets("PIVOT_TB").Copy(oTargetSheet)
Set oTargetSheet = Nothing


Any help much appreciated. Thanks

Jeremy
 

A:Solved: Excel VBA to move worksheet to new excel file

Read other 8 answers
RELEVANCY SCORE 80

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 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ím barely able to get anything done! Please help, Iím dying here!
 

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

Read other 16 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

I have tried to apply Themes to my Worksheet but the only thing that changes is the font. Color and Effects do not change.

Help Would be Appreciated

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 8.1, 64 bit
Processor: Intel(R) Core(TM) i3-4130 CPU @ 3.40GHz, Intel64 Family 6 Model 60 Stepping 3
Processor Count: 4
RAM: 8108 Mb
Graphics Card: Intel(R) HD Graphics 4400, -2016 Mb
Hard Drives: C: Total - 942195 MB, Free - 791640 MB; D: Total - 476813 MB, Free - 10813 MB;
Motherboard: Dell Inc., 088DT1
Antivirus: McAfee Anti-Virus and Anti-Spyware, Updated and Enabled
 

A:Themes Not Working in Excel 2010

Funny, I never in my entire Excel time used themes, I just tested it on my also 2010 version and nothing happens except to the font, but ....

I tried some more, let's say to change the header row and do something with it
Make the header row background grey with bold black font.
Now apply a theme then you'll see it change to the colors of the them.
If I understand correctly a theme is that. it applies to all things you do extra to a sheet.
If you create a table and things like that and then apply a them you'll see not only the font change but the rest too.
I guess you'll just have to dig a little deeper, I just found this out in the past 5 minutes
Good luck
 

Read other 1 answers
RELEVANCY SCORE 78

While in excel, I would like to open another excel file and read some information.

The file I am reading from, will have a row with "Avg." in Col A with data in Col B through L in that row that I want to extract. The data line will be in a different place in all excel files and there may be 2 lines to read.

At this time, I have used the Open command successfully to find the file but do not know how to proceed (?the open structure may be wrong?).

I am familiar with loops and variables but can can not figure out the rest unique to excel.

Any help would be appreciated.
 

A:Solved: Read excel file B while in excel file A

Read other 16 answers
RELEVANCY SCORE 78

I have been using Excel 2011 (Mac), but when I try to save or copy worksheets over to Excel 2013 onto my PC the sheet layout changes. Not only do I need to adjust the row height and column widths afterwards, but the zoom level too. All this I find time consuming when I have a number of worksheets.

I understand you can save to an older Excel version, but how do I save from 2011 to the latest 2013.

Thanks
 

A:Solved: Saving from Excel 2011 to 2013

Hi, I'm not MAC man but besides the format and zoom issues maybe this link can help you along the way
http://office.microsoft.com/en-us/mac-excel-help/file-formats-for-saving-workbooks-HA102927677.aspx

Another link:

http://sysmod.wordpress.com/2011/10/28/mac-excel-vs-pc-excel/
 

Read other 2 answers
RELEVANCY SCORE 78

I have the following issue every time I try and save one excel workbook that was sent to me and I need to work on it frequently it will not save.

The OS that I&#8217;m running is windows 7 Professional 32bit the office application is MS Office 2010 Standard. Every time I try save the file I get the following error &#8220;Errors were detected while saving &#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;.. 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.&#8221;

If I click continue Excel freezes up and has to be shut down via task manager if I press cancel it does not save the document. Now I have checked the following on the document.

Permissions on the excel workbook are go

Disabled add-ons on excel

Changed Excel file name

Change file to 2003 format and still having same problem as 2010 format

Cleared all Temp files form the temp Folder

Opened the excel file using the open and repair feature

Uninstalled and reinstalled MS Office 2010

Performed a repair on the installation

All other excel files work fine on this computer I have created new workbooks and saved them without any issues I have emailed the file to a different PC with the same specs and can save the file fine without having to make any changes to the system or excel file.

Is there anythi... Read more

A:Excel 2010 Saving file problem

Is the file from previous version of excel?
I once have such issue, only to find out and old macro code causing the problem.
one such error will be having range = something instead of set range = something.
Compiler will not throw out errors of such.
 

Read other 2 answers
RELEVANCY SCORE 78

I'm working on two MS Office 2010 Excel files one of which consists of unorganized text data (from a survey) typed on four separate worksheets each under a different question heading. The other file consists of the same text data on one worksheet organized under the same question headings in columns B, C, D and E - respondents' job titles, which they provided when they completed the survey, are in column A.

I'd like to be able to compare these two files but have yet to find anything that works for me. I've checked Microsoft support and other sites - the latter describe how to do this in earlier versions of Excel by activating the VBA Add-in but were short on details of how to do that. Any suggestions would be greatly appreciated.
 

A:MS Office 2010 Excel file comparison

how do you want to compare? Are you just looking for duplicates?
 

Read other 10 answers
RELEVANCY SCORE 78

I use Windows 7 and Excel 2010. I created a file and was using it for some time and now when I try to open it it says either "Access denied. Contract your administrator." or "You don't have permission to open this file. Contact the file owner or an administrator to obtain permission."

I created the file. I do network with 2 other computers and everything is stored on one of those. Those computers have older versions of Microsoft Office, but we haven't had a problem with any other file. It appears that somehow this file was saved as an Excel worksheet (xlsx) (I guess in 2010) even though I have it on the setting to save as a 1997-2003 file. Usually it will still open after converting on the other computers. When they try to open it says "Cannot access read-only document" but the read-only is not checked in properties.

I NEED to get in to this file...how do I do it???
 

A:Excel 2010 access denied to one file

f1prop said:


I use Windows 7 and Excel 2010. I created a file and was using it for some time and now when I try to open it it says either "Access denied. Contract your administrator." or "You don't have permission to open this file. Contact the file owner or an administrator to obtain permission."

I created the file. I do network with 2 other computers and everything is stored on one of those. Those computers have older versions of Microsoft Office, but we haven't had a problem with any other file. It appears that somehow this file was saved as an Excel worksheet (xlsx) (I guess in 2010) even though I have it on the setting to save as a 1997-2003 file. Usually it will still open after converting on the other computers. When they try to open it says "Cannot access read-only document" but the read-only is not checked in properties.

I NEED to get in to this file...how do I do it???Click to expand...

Let's see if it is a permissions error.
Try right clicking on the file (before you open it), go to Properties, Security, under "GROUP OR USER NAMES" click on yourself (your username), then check on the box below that " PERMISSIONS FOR ________" and check to see that you have READ privileges. If you see a check mark next to "READ" then you do, if you don't have a check mark there go to "EDIT", click on yourself, and click on "READ" ALLOW's check mark. Check and see if... Read more

Read other 1 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 77.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 77.2

Hi,
I have been using these forums for a while, however haven't bothered creating an account until now.

I have had some trouble with an excel document I created in office 2010 on PC.
When i tried it in office 2011, the program freezes as soon as a certain script is triggered.

It may be that i am using an activX feature, however, I do not know how to tell.

The basic part that doesnt work on mac is:
Code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Application.Intersect(Target, Range("B5").CurrentRegion) Is Nothing Then Exit Sub ' Limits range to B column AND existing customers

EditAccount.Show
End Sub
If you can help me out I would be very appreciative.

Cheers,
Tom.
 

A:Solved: Compatibility prob. excel 2011 mac using VBA macros

Read other 6 answers
RELEVANCY SCORE 77.2

Hi, when I try to open my excel file, I get the error 2010 calling list.xls:: file format is not valid. Does anyone have a program they can use to try and open my file. I'm assuming it was corrupted the last time I tried to save it.
 

A:file format is invalid error in Excel 2010

are you getting it in all excel files? Or only the one?

You can try downloading openoffice; I've used that to fix many MS Office corrupt files in the past, particularly .ppt files.
 

Read other 2 answers
RELEVANCY SCORE 77.2

Hi Folks,

I just changed out my President's XP-Pro to Win7 Pro 64 bit.

We store all of our Word & Excel docs on a 6.5 Netware server.

Yes it's old and out of date - but it cost money to change it. so.....

I had no problems ever with XP but with Win7 when you open a Excel file it
give the old BSOD.

It may not do it every time, sometimes I have to open, close a couple of times and then it happens.

I have no other problems in connecting to the Netware server.
BTW - I'm using the Novell Cient 2 SP2 for windows 7

This is a new Lenovo desktop M series with Intel I5 4g of system memory.

I cannot find any problems with the hardware.

Minidump is attached

Thanks for your help
Jim

A:Excel 2010 crashes (BSOD) when opening a file

Hi

The dump file point to nccache.sys as the cause of the BSOD... this is a know bug with Novell.

Please follow this workaround suggested by Novell by disabling the file caching.

Read other 3 answers
RELEVANCY SCORE 77.2

When I try to save a file to a folder I have in MS Excel 2010 I don't see all the that are really in that folder. Only the last 10 or so are there. My boss is trying to save an excell document into his Project Folder but when he hits save as only certain documents show up and none of them are the Folders that are definately created and can be accessed when you go to Windows Explorer. Is there a way to change this?
 

A:MS Excel 2010 - Saving File - Can't see all folders in Save As

Read other 10 answers
RELEVANCY SCORE 76.4

ms office excel 2010 symbol not working to insert on page, , all the symbols when you press " insert " symbol and the character box opens.in microsoft excel and word. what might be the issue....

A:Ms office excel 2010 symbol not working to insert on page

Please we need a little bit more information. What symbol? What page?

Kari

Read other 1 answers
RELEVANCY SCORE 76.4

I think this problem may have to do with Windows 7 vs Windows XP. With Excel 2010 running under XP this does not happen.

Under Win 7 running Excel 2010, when saving a spreadsheet as a tab delimited text file (.txt). Excel 2010 appends the .txt file extension to a file that already has an existing file extension. For my work I must save excel files as xxxxxxx.upl but excel always saves the files as xxxxxxx.upl.txt. This only occurs under Win 7, not XP which is why I think it is an OS issue.

How can I fix this? I am guessing it is a registry fix, but I don't have any ideas of how to fix it. Thanks in advance for any suggestions!

If I add double quotes around the file name I want, like "xxxxxx.upl" the file will save as a tab delimited text file and Excel will then identify the file type as a UPL file.

What I want:

What I get without the "xxxx.upl" file name:

A:Stop Excel 2010 from appending .txt to file with existing extension

Yep, that option is called "Hide extensions for known file types".
Likely, on your XP system it is turned ON (checked) and on your win 7 machine is it turned OFF (unchecked).
But that would work for all known file types, not just the one specified.

Tutorial File Extensions - Hide or Show

Read other 9 answers
RELEVANCY SCORE 74.8

I have the following formula in a cell:

=IF((Sheet2!$F$8=Sheet2!$AK$3),(Sheet2!$C$2),(""))

I need to copy this fomula down through 174 rows with the 'sheet number' increasing by 1 in each row.

So the next row should read:

=IF((Sheet3!$F$8=Sheet3!$AK$3),(Sheet3!$C$2),("")) and so on for 174 rows. Is there a way to do this without editing every row?
 

A:Solved: Copying a formula in excel 2011 to increase sheet number by 1 each time

Read other 7 answers
RELEVANCY SCORE 74.8

Excel 2010 SUM Formula updates, save file and reopen - values revert to old yet SUM totals are new

Hi guys
We have a very strange problem, our user opened his .xls document (97-2003 format) yesterday and updated several values, copied formula and updated (eg monthly/weekly totals). The worksheet includes many small SUM's spanning a couple of cells with sub-totals. He then saved his work and shut down as usual.
When opening the .xls document this morning, to continue his work, he noticed some of the values had changed (we assume to the previous ones) yet the totals where still the updated 'saved' values. Changing any values causes Excel to recalculate the totals (which then become correct, yet old totals)
Yesterday I updated the computer from a Windows XP (SP3), Office XP (SP3) to a Windows 7 (32bit, SP1), Office 2010 (SP1).
We've advised him to change document types to the new .xlsx format and to doublecheck everything.

Any ideas to the actual cause? Thanks
 

A:Excel 2010 SUM Formula updates, save file and reopen - values revert to old

Read other 6 answers
RELEVANCY SCORE 74.4

Hi,
I'm working with Excel 2010

I use an Excel xlam file as a container for many functions and this is working fine no problem there
When I first created the xlam file I left it with 4 worksheets whihc now contain reference data and named ranges.
I want to add a new worksheet to those already present but the process which works for copy a sheet from the xlam file to 'normal' file will not work the other way around.

I'm trying to put the following code to work
Code:


Public Const BSOAddin As String = "BSO Rapportage.xlam" '* main xlam module for menu and vba code

Sub myRangesSheet()
Dim myXlam As Workbook ' if I dim is As Addin I get a syntax type mismatch error in the following line
Set myXlam = Workbooks(BSOAddin)
'Exit Sub
If FolderExists(myXlam.path & Application.PathSeparator & "CONFIGURATION") = False Then Exit Sub
If FileExists(myXlam.path & Application.PathSeparator & "CONFIGURATION" & Application.PathSeparator & "Ranges.xlsx") = False Then Exit Sub

Debug.Print myXlam.Sheets(1).Name ' Just to show that Sheet(1) in the xlam file is there nothing more
Dim wb As Workbook

' I open the workbook that contains the one sheet I want to copy to the xlam file

Set wb = Workbooks.Open(fileName:=Workbooks(BSOAddin).path & Application.PathSeparator & "CONFIGURATION" & Application.PathSeparator & "Ranges.x... Read more

A:Solved: Add an extra sheet to a xlam file

Read other 9 answers
RELEVANCY SCORE 74.4

I have a document in Excel 2010 which contains 2 columns. Data from 2nd column is constant, does not change and is assigned to data in 1st column. Names and surnames are great example, so I will use this case for explanation.

Currently there are 200 names in 1st column and of course 200 surnames, attached to them in every row. There won't be any new names ever.

This is functionality I'd like to have. I often have to copy some of those names from external database (software) in various numbers. Let's say 50 random names to 1st column. But when I do that, I have to manually write down surnames to 2nd column, because they come from another database (software) which is not synchronized with the first one, so I cant just copy/paste them.

Is there any way to save (connect?) all 200 surnames to all 200 names in Excel, so when I would copy some of names from external database to 1st column, Excel would automatically attach appropriate surname to 2nd row?

I hope I was clear. Thanks for help in advance!
 

A:Solved: Excel 2010 help

Read other 7 answers
RELEVANCY SCORE 74.4

Hi There,

What I have is a spreadsheet with several sheets. I have created a summary sheet that I want to pull all the active information out if it meets a certain criteria.

I have the formula's put together so that it pulls the info correctly, but I need to know how to format the page so that it auto sizes the number of rows shown. I did it once before abotu 4 years ago.. but I can't figure it anymore.

I hope I'm explaining myself well. but here is a second go just in case. The formula to pull the data from each sheet is placed on the entire sheet (so that when that cell is populated the summary sheet will update) but I don't want the summary sheet to show hundreds of empty cells until they meet the criteria, I'd like it to only increase what you can see when they are populated. Thank you!!!
 

A:Solved: Excel Help 2010

Read other 7 answers