Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

xlsx vs xls

Hi everyone,

I'm in a huge mess. I need someone's help asap. I gave Office 12 Beta a try
and while working in it, saved a document in xlsx format. The trial period is
over and I've uninstalled the software, but I forgot that I need the
information that I've created in xlsx file.

I'm trying to open it in my old Office 2000 and its not opening. I was
wondering if one of you could open this file in Office 12 and resave it in
old xls format, so I can get the content out of it, please..

http://www.stratacrystal.net/list3.xlsx

p.s. For some reason when you download the file from that server its comming
down as zip?? You need to change the extension to xlsx and then open it in
Office 12.


Post your answer or comment

comments powered by Disqus
Hi everyone,

I'm in a huge mess. I need someone's help asap. I gave Office 12 Beta a try
and while working in it, saved a document in xlsx format. The trial period is
over and I've uninstalled the software, but I forgot that I need the
information that I've created in xlsx file.

I'm trying to open it in my old Office 2000 and its not opening. I was
wondering if one of you could open this file in Office 12 and resave it in
old xls format, so I can get the content out of it, please..

http://www.stratacrystal.net/list3.xlsx

p.s. For some reason when you download the file from that server its comming
down as zip?? You need to change the extension to xlsx and then open it in
Office 12.

How can I change from the exel file extention .xlsx to .xls ?
Since the other users can not open .xlsx extention.

I’m having startup performance issues related to Excel 2007. The following
timings further describe this issue.
Without previously opening Excel:
A simple (30 column, 200 row) spreadsheet opened by clicking on the XLSX or
XLS file requires 60 – 62 seconds go open and display .
With excel open.
The same spreadsheets that required approximately 60 seconds to open in the
first example will now open in 2- 3 seconds
Time required to open Excel via Program Start (no spreadsheet), is very
quick, requiring approximately 2 seconds.
The computer I’m using is a Toshiba p15 S540 with 2 gigs of memory and 80
gigs of disk, defraged, with approximately 20 gigs of available disk space.
“About” shows version 2007 (12.0.4518.1014) (Office Ultimate 2007 -
upgrade). Uninstall and reinstall had no impact on the issue.
Any suggestions?

Thanks,
Dan Riker

Which converter .exe will convert .xlsx files into .xls for excel 2003?

I've found two different .exes offered by MS.

Thanks.

Hi experts can qny one having macro to convert xlsx to xls.

i have folder excel files .xlsx format & i want to change all files into .xls format any shortcut & any trick

manually one by one open file & save as into 97-2003 then save

using office 2007

I have got Windows XP with Office 2003.
I downloaded the Compatibility Pack and then the CP SP2.

Unfortunately when I open an xlsx file, the conversion starts and gets stuck!
Nothing happens then until I terminate EXCEL.EXE and excelcnv.exe processes.

Because I noticed a connection is activated by excel to the internet during
conversion, I disabled the firewall. But nothing changed.

Help needed.

Hi, I emailed excel file created at home in excel 2007 for opening in excel
2002 (work pc). it turnes out that excel 2002 can not open .xlsx file created
in 2007 version.
Could you pease assist how can I convert the the file?
Thank you in advance!

I am still using 97Office Excel. My customer sent me excel files in xlsx
format this morning.
I could not open those xlsx files.
I now downloaded the converter for xlsx to xls format.

My question is whether the converter (FileFormatConverters.exe) could work
on 97Office Suite.
TIA. Jorge

Hi all,

I've been struggeling with this matter for a long time time and sometimes I've been able to solve my problems with setting the calculation in XL 2003 to manual but sometimes it doesn't help...

I have an application in XL97 that I'm currently rebuilding in XL2003. This following code is setting the rowheight to 0 if the target is 0 or < then "A". This codes run for about 2 seconds in XL97 and it takes around 5-10 minutes in XL2003 !!! What can I do to speed it up, any suggestions ?

I'm greatful for all the help I can get !

Br,
Pijay


	VB:
	
 Worksheet_Activate() 
     
    Dim rnOmrade As Range, rnCell As Range 
    Dim rnOmrade2 As Range, rnCell2 As Range 
     
    Application.CommandBars("Web").Visible = False 
     
    Application.ScreenUpdating = False 
    Application.Calculation = xlCalculationManual 
     
    If Range("Ner_Uppföljning").Value = 0 Then 
        Call VisaAllaSpaceAndra 
        Set rnOmrade = Range("a8:a1000") 
        Application.ScreenUpdating = False 
         
        For Each rnCell In rnOmrade 
            If rnCell.Value < "A" Then 
                rnCell.EntireRow.Hidden = True 
            End If 
        Next rnCell 
         
        Range("c8").Select 
        ActiveWindow.FreezePanes = False 
        ActiveWindow.FreezePanes = True 
        Range("c8").Select 
        ActiveSheet.Protect Password:="whizz2001" 
    Else 
        Call VisaAllaSpaceAndra 
        ActiveSheet.Unprotect Password:="whizz2001" 
        Set rnOmrade2 = Range("d8:d1000") 
         
        For Each rnCell2 In rnOmrade2 
            If rnCell2.Value = 0 Then 
                rnCell2.EntireRow.Hidden = True 
            End If 
        Next rnCell2 
         
        Range("c8").Select 
        ActiveWindow.FreezePanes = False 
        ActiveWindow.FreezePanes = True 
        Range("c8").Select 
    End If 
     
    Application.Calculation = xlCalculationAutomatic 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


I am creating a customized workbook that uses numerous VBA routines using a
Windows version of Office (97, 2000 or 2002). From my understanding the code
should run the same in the Mac vesion of Excel. Is this correct? Also, are
there any issues I should be aware of where code compatibility is concerned?
This is my first experience with XL for Win vs. XL for Mac. Any help would
be appreciated.

Is the newer version of XL that much better than 97?

I have a copy of Office '03 Student and Teacher edition, but have never
bothered to install it. Are the improvements in it actually worth the
effort to mess with it?

Hey everybody,

all of a sudden, getOpenFilename does not work anymore in a workbook I am working on - it worked fine until 30 minutes ago and I did not change anything related to it. The only things I really did were to record a macro and add solver to the references for the VBA editor. Now, whenever I click the button that refers to getOpenFilename, I get a "Compile error: Method or data member not found"

The function that gives me the error message is very simple:


	VB:
	
 btnNewOutpFile_Click() 
    Dim fileString As Variant 
    fileString = Application.GetOpenFilename("Excel Files (*.xlsx;*.xlsm; *.xls), *.xslx;*.xlsm;*.xls", 1, _ 
    "Please choose an output file!") 
    If fileString  False Then 
        Me.txtOutpFile.Caption = fileString 
    End If 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
(txtOutpFile is a label in the Userform)

It is within a rather simple UserForm. Does anyone know what might cause this? Could not find anything on google or ozgrid that was related...

Dear all,

I am a consultant and expert Excel user but have come across a problem I have not been able to solve.

I have built a financial model, but something has caused the file to grow from 1.6MB to 36MB without explanation.

FILE DETAILS

Originally, the file was 1.6MB, .xlsm, built in Excel 2010 and Win7, and was working extremely smoothly.

The file design involves:

- 15 "assumptions" worksheets for inputs (raw value inputs only, virtually no calculations)
- 1 "calculations" worksheet (2500 lines long, 20 columns wide, heavy calculations)
- 8 "reports" worksheets (virtually no calculations, only linking to calculations sheet).
- There are no macros or other VBA code
- There are no data tables
- I have used some named ranges but none are linked to other workbooks or giving errors
- There are no (apparent) links to external files

PROBLEM

An employee of my client attempted to make some changes to the Calculations sheet.

Somehow, the file has shot up to 36MB and has ground to a halt.

ATTEMPTED FIXES

I have copy / past values on every cell in the sheet and I'm still at 10MB.

Changing file type from .xlsm to .xlsx made no change
Changing file type from .xlsx to .xls dropped file size to 2.5MB, but still larger than the original 1.6MB and probably due to loss of formatting and 2010 features such as sparklines

HUNCH

Is it possible that Excel has an inbuilt RAM function or somehow "carries" linked or source files that may increase the .xlsm file size substantially?

Is the increase in size due to some background looping that is invisible to the standard user interface?

I am attempting to narrow down and isolate individual lines of calculations that may be the problem, but am concerned something is happening invisibly in the background.

HELP

Any suggestions?? This one is a stumper!

Thanks in advance,
Jax11

I have a chart that was created in XL2003 but the user has just be upgraded to XL2007. When he opens his chart in XL07, his data label values are missing. I open the same chart in XL03 and the labels are there; they just don't show up once it is saved in XL07. It doesn't matter if the workbook is .XLSX or .XLS.

Also, he needs to connect a dashed line from one point to another but the data is not contiguous. There are 2 blank cells between the first point and the last. I know this problem has been addressed before but I can't seem to find the solution that works for my user.

Can anyone help?

Good afternoon everyone,

Just as a basic introduction, My name is Gene, and I'm working at a company
producing a CRM database, which includes an Excel template file that I
provide the employees to fill in so that they may fill in the contact details
while away from the database and add them whenever possible.

I have my database currently linked to an Access database, so that on
start-up of the Excel file (I've saved both an XLSX and XLS format for
testing purposes) the excel spreadsheet will update any details (if changed)
for lists such as countries, employees and services (list of divisions of the
company).

I have no problem creating the data link between the two, and the the
'connections' settings and 'properties' are all set to how I would like them
to work.

The imported data for the countries, employees and services are all saved in
their own individual worksheet. Now, the idea is to have a drop-down list
(from Data Validation) to list the countries, employees and services as
stored in the independent worksheets. What I experienced with Excel is that
Excel can't use a data range which might change in size; it prefers to refer
to a fixed range (a fixed number of cells, a single column/row). So I had to
select the column where the data sits. I named each column with titles such
as "Country", "Service" and "Employee".

I used the Data Validation tool to locate each range, and the list works
perfectly. However, when I intended to use error checking for invalid data,
it doesn't work. If I enter in the wrong information, it passes the error
checking and doesn't register as invalid data. Now I have a problem of trying
to solve this problem.

Has anyone else experienced this? What is the solution?

Thanks for your help everyone,

Gene.

Hi All...........
I have a file that takes about 90 seconds to recalc............using XL97.
Can anyone tell me please if it would be any faster by ONLY upgrading to a
newer version of Excel?

Tks,
Vaya con Dios,
Chuck, CABGx3

I want to save an excel file in the csv as this is the format my address
program wants for import. BUT, when I go to "save file as" there is no "text
file" option, and no csv option under "other formats". I formatted all cells
as text, and I deleted all the other sheets in the workbook. I've tried with
the original file in both xlsx and xls formats.

I am trying to create a shortcut method for toggling between Auto/Manual
calculation mode. I have two menu items, one in the right-click menu and
one off of the worksheet menu. As part of both menu items, I update the
..State property based on Auto or Manual. In order to make this work if the
user chooses the Tool/Options method of changing calculation mode I am
attempting to use a class module/WithEvents with various application events.
The code below works fine when I run it from the .xls file, however, as soon
as I save/install it as an .xla file I get a 'Run-time error 13: Type
mismatch' error at the commented line in the InitCalcMode procedure.

I have tried eliminating the Call InitCalcMode in the Open procedure
thinking the workbook open event would capture it, moved the Set AppClass
line in the Open procedure to the last line, and tried changing the If
Application.Calculation to If App.Calculation and If AppClass.App with no
luck. I am guessing that there is something different about programming for
..xla mode vs .xls but I don't know what it is. Any help is greatly
appreciated and sorry for the long post but I wanted to give as much
information as I could. BTW, I am using XL2003 and WinXP.

In the ThisWorkbook module:

Option Explicit
Dim AppClass As New clsEventClass

Private Sub Workbook_Open()
Set AppClass.App = Application
Call MakeMenu
Call InitCalcMode
Application.OnKey "+^{D}", "modStartEndTime.StartEndTime"
End Sub

In a class module named clsEventClass:

Option Explicit
Public WithEvents App As Application

Private Sub App_NewWorkbook(ByVal Wb As Excel.Workbook)
Call InitCalcMode
End Sub

Private Sub App_SheetActivate(ByVal Sh As Object)
Call InitCalcMode
End Sub

Private Sub App_SheetCalculate(ByVal Sh As Object)
Call InitCalcMode
End Sub

Private Sub App_SheetSelectionChange(ByVal Sh As Object, ByVal Target As
Range)
Call InitCalcMode
End Sub

Private Sub App_WorkbookOpen(ByVal Wb As Excel.Workbook)
Call InitCalcMode
End Sub

In a general code module:

Sub InitCalcMode()
Dim oCtrl1 As CommandBarButton, oCtrl2 As CommandBarButton

On Error Resume Next
Set oCtrl1 = CommandBars(1).FindControl(Tag:="PIMS
TIPS").Controls("AutoCalc")
Set oCtrl2 = CommandBars("Cell").FindControl(Tag:="PIMS
TIPS").Controls("AutoCalc")
On Error GoTo 0

If Application.Calculation = xlCalculationAutomatic Then ****Error
occurs here****
oCtrl1.State = msoButtonDown
oCtrl1.ShortcutText = "AutoCalc ON"
oCtrl2.State = msoButtonDown
oCtrl2.ShortcutText = "AutoCalc ON"
Else
oCtrl1.State = msoButtonUp
oCtrl1.ShortcutText = "AutoCalc OFF"
oCtrl2.State = msoButtonUp
oCtrl2.ShortcutText = "AutoCalc OFF"
End If
End Sub

Hi Guys,
I am trying to write a macro to loop through all the subfolders in a main folder and open the latest excel workbook on the basis of latest modified date and time . I have something that does this but i have to manually change the subfolder name and file extension, I want it to look for files with .xlsx and .xls , when inside a subfolder. Any help will be highly appreciated.

Thanks
Roop

Here is what i have right now.

Sub LastModifiedFilewithinFolder()

Dim strFile As String, strFolder As String
Dim dtLast As Date, strLMFile As String

strFolder = "T:HVM LSPF32PCDP1270BT"
strFile = Dir("T:HVM LSPF32PCDP1270BT*.xlsx*", vbNormal)
Do While strFile <> ""
If FileDateTime(strFolder & strFile) > dtLast Then
dtLast = FileDateTime(strFolder & strFile)
strLMFile = strFolder & strFile
End If
strFile = Dir
Loop

MsgBox "Last Modified file is : " & strLMFile
Workbooks.Open (strLMFile
)

Hi Excel Experts,

Every month i will get different workbooks namely (crs.xls,tr.xls,sat.xls,vs.xls,air.xls etc...)
All the workbooks have a common sheet (sheet name as "sample")
All are kept in a folder(folder name as "Nodes") on my desktop.

Note:-
1)"sample" sheet maintain same structure (i.e., column names and number of columns are same) and the data is present in same cells of all the "sample" sheet.(i will attach the sheets if needed)
2)"sample" sheet maintains a unique column (namely "CSR ID") which as unique data (some id number) in it.

Now,
1)i want to copy/import data from those workbooks(crs.xls,tr.xls,sat.xls,vs.xls,air.xls etc...From “sample" sheet) to an another workbook called "reports.xls” in to "outages" sheet ("reports.xls" as different sheets in it)

Criteria:
1)when ever i copy/import data from workbooks(crs.xls,tr.xls,sat.xls,vs.xls,air.xls etc...),the data in PK column(i.e. CSR ID column) has to check in "outages” sheet in (CSR ID ) and then copy/import it only if it was not available(to avoid duplication).

Any macro's/button that can solve this problem.

Hi,
I'm using the following code to add 4 worksheets from another worksheet to
the active workbook.
It works great..unitl I change the Workbook name to the addin file name of
"WCAddin.xla"...which is how I need to run that file.
I get a Run Time Error --Application- defined or object defined error
message.
Is this due to me changing the workbook file name to xla vs xls?
If yes.. how would I rewrite the code to work with the addin file instead?

Public Sub AddWStoWCTemplate()

Workbooks("WCAddin.xls").Sheets(Array("Summary", "Adjustments", "Details",
"Calculations")).Copy After:=ActiveWorkbook.Worksheets(Worksheets.Count)

With ActiveWorkbook
For i = .Worksheets.Count To .Worksheets.Count - 3 Step -1
With Worksheets(i)
.Range("A1").Formula = .Range("A1").Value
.Range("A2").Formula = .Range("A2").Value
.Range("A3").Formula = .Range("A3").Value
End With
Next
End With

End Sub

Please see attached file. Both files are the same, just different version of Excel.
ex1.xlsx

ex2.xls

I left fields on the right exhaustively explaining the formulas needed, but here it is in a nutshell: there's basically 4 equations that are very similar in nature. They all deal with these two columns that contain integers from 1 to 5, with some blanks. Also, it's important that all rows that are missing 1 or both numbers are not counted at all. I need formulas that:

count the rows in which there was an increase from column A to column B

count the rows in which there was a decrease from column A to column B

count the rows in which there was no change from column A to column B

count the rows in which there was an increase of at least 2 points from column A to column B

...However, I also need it to be segregated by starting point. That is, "How many rows that started with 3 in the first column showed and increase from A to B?" and so on, for each of the 5 possible numbers. It's more clear when viewing the file. Really, it would be ok if you just helped me solve this for 1 integer, and I can just plug in the different numbers to make it work.

You'll notice in the file there are actually 4 columns, but both deal with the same questions and types of data, so it would be easy for my me to copy formulas from "ela" to "math."

Thank you very much for any and all help!

The formula in cells R7 and S7 don't calculate. When I fill in the numbers in cell J7 and K7 manually it works, but when I use a link to cell T3 and T4 it won't work. Hope someone can help me out.

I have checked the format of the sheet. Doesn't work when all the cells have the same format...
Formula's I am using are not the most difficult ones:

ABS(J7-K7+100)
IF(C7=0;"";SUM.IF($AA$3:$AA$28;N7;$AB$3:$AB$28))
IF(J7>K7;SUM.IF(W:W;L7;X:X);SUM.IF(W:W;L7;Y:Y))
ROUND(1/(MACHT(10;(-W7)/400)+1);3)

Solution must be simple, right? I must be overseeing something.
I am using the Dutch Excel 2007, but I tried it with the English one and it wasn't working either.

ForDoesntWork.xlsx
ForDoesntWork.xls
FormulaDoesntWork.gif


No luck finding an answer? You could always try Google.