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

Free Microsoft Excel 2013 Quick Reference

set Excel 2007 as default to save files in Excel 2003 .xls format

I want to set Excel 2007 as default to save files in Excel 2003 .xls format.
I use accounts report software called FRx which automatically generates
Excel format files distributing them as email attachments, but many users
only have 2003. Running the version of FRx software I have, in 2007
environment, is outputting Excel 2007 format files with a file extension .xls
which Excel 2003 (rightly) does not recognise because it is the wrong file
extension for the actual format of the file.
I'm thinking that if 2007 will pre-set to output 2003 then things might run
OK, with the down side that in normal use I'd have to manually choose to save
as 2007 format.


Post your answer or comment

comments powered by Disqus
How do I set Read-Only Recommended as default to save files in Excel 2002?

Thanks.

Post title: Problematic chart issues in Excel 2007
Post date: 9/29/06
MS office version: (12.0.4017.1004) MSO (12.0.4017.1003) BETA.
Program: Excel
Problem: Excel appears to have some issues with chart/graph function. This
new version will not display or maintain Chart settings . If I change the
chart type the changes do not always appear or appear wrong. The whole chart
function in Beta version appears to have some serious issues. I am using same
machine that has had Office XP (2002) and Office 2003 running without these
problems. Only possible thing I can think of is the fact that I am having
Excel default to saving files in Excel-97-2003 version (*.xls) and therefore
can see a possible problem when one reopens a file. However, the problem is
there even before saving the file. Does Excel somehow know that since the
file is an *.xls not a *.xlsx limit the graphing possibilities while you are
actually working on the file?
Background: I have been using excel to process and graph data for over ten
(10) years and feel I know what I am doing.

Hey,

I am looking for a solution to save targeted column each cell of my excel sheet as a separate .txt file (Western European text format [windows-1252]) at ones.

What I have:

Name Bonus Right
ABBANK | 10% | 1:R1 |
FAS | 20% | n/a |
BDFINANCE | 35% | 2:R1 | etc..

In this case the name of the text file (e.g. ABBANK.txt) and all the other Column cell contain the information with column heading, I would like to see in the text file.

D:My DocumentsABBANK.txt
Bonus : 10%
Right : 1:R1.

D:My DocumentsFAS.txt
Bonus : 20%
Right : n/a
etc.....

Anyone ideas? please help me.

Hey,

I am looking for a solution to save targeted column each cell of my excel sheet as a separate .txt file (Western European text format [windows-1252]) at ones.

What I have:

Name Bonus Right
1. ABBANK | 10% | 1:R1 |
2. FAS | 20% | n/a | .
3. BDFINANCE | 35% | 2:R1 | etc..

In this case the name of the text file (e.g. ABBANK.txt) and all the other Column cell contain the information with column heading, I would like to see in the text file.

D:My DocumentsABBANK.txt
Bonus : 10%
Right : 1:R1.

D:My DocumentsFAS.txt
Bonus : 20%
Right : n/a
etc.....

Anyone ideas? please help me.

I have been using Excel 2007 to import comma delimited text (csv) files
stored on my local hard disk into my personal finance spreadsheet. The
Data>Get External Data>From Text wizard works fine and have had no trouble
using the Refresh function. The problem comes from accessing a Connection
Properties Box from the Data>Connections Box. If I select OK after viewing
the Properties Box, Excel crashes, restarts, and offers to let me continue
working on a repaired worksheet. This behavior occurs even when no changes
are made in the Properties Box. If I select Cancel, Excel exits the
Properties Box normally. This behavior also occurs in a clean workbook with
no data other than an imported text file.

This behavior is not a fatal flaw since there are other ways to access and
change the property data, however, such behavior is not acceptable in a
Microsoft Product which has been around for about 20 years. Is this a bug in
a new release of the product or a problem with the installation on my
computer? I am using Office 2007 Home and Student Trial Edition on a WinXP
Pro SP2 system. To preserve file portability I am opening and saving
worksheets in the .xls format using the Excel 2007 compatibility mode.

Any comments on this behavior?

--
Fritz Jones

Hi

Does anyone know the macro command to open a file in read only format?

Thanks in advance.

I have a Excel 2007 macro-enabled template (.XLTM) which I use regularly.
Whenever I open this template then use save or save as to create a new file
the default workbook type of .XLSX is selected instead of .XLSM.

How can I change the default behaviour for this template to automatically
select a .XLSM format in the "Save As" dialog wihtout changing it for every
document as happens by using the 'Excel Options>>Save>>Save Files in this
Format' drop down box.

Cheers

Hi,

Wonder if anyone can help.

I have a excel file with english terms, which I sent to translators to translate into Tamil language.
When the file comes back, it shows rubbish characters:
e.g.:
Col A: Col B:
Acting nFtftlf

I was told to install a mylaiplain font set on my PC to be able to view it. I did it and is fine.
However, I'm actually using the terms in this excel file to be import into a system/server, which will publish the words on html web page. But with the import, it does not work - on the system end, it does not show the Tamil characters.

I was told that I need to save the file and preserved it's unicode. I'd like to ask how to do that. Cos, if I told the translators to click save as and select the file type as unicode, it will be saved as a *.txt file. However, the import process into this server requires a .csv or .xls or any properly delimited file.

can someone advise how can the unicode be preserved in the excel file? The software that the translator used is called mylaiplain.

Please help..

2007 & 2003

Note to the file - so to speak:

Even if one changes Excel 2007's default file SaveAs format, when
2007
closes, it saves files like Personal.xls as a 2007 file format
without
the new extension .xlsx

My point, I still must save files in 2003 for other's who do not have
2007.

If I copy Personal.xls in the Excel StartUp Directory to a 2003
platform, Excel 2003 does not recognize the file format. (The file
size is about 50% of the original 2003 file size - which is a strong
hint that the file is in the new XML format)

Therefore, I created a macro to save Personal.xls in the 2003 format
in a different directory of my C drive:

Workbooks("PERSONAL.XLS").SaveAs "C:Excel Information
Personal.xls", FileFormat:=xlExcel8

EagleOne

I recently installed Office 2010 Beta. When i click on an excel file it
automatically opens in Excel 2007. How do i make Excel 2010 default when i
open an excel file?

How do I make the "Save As" default to the folder where I saved the previous Excel file?

Thanks!

User Interface
New User Interface
The new results-oriented user interface makes it easy for you to work in Microsoft Office Excel. Commands and features that were often buried in complex menus and toolbars are now easier to find on task-oriented tabs that contain logical groups of commands and features. Many dialog boxes are replaced with dropdown galleries that display the available options, and descriptive tooltips or sample previews are provided to help you choose the right option.
No matter what activity you are performing in the new user interface, whether its formatting or analyzing data, Excel presents the tools that are most useful to successfully complete that task.
Introducing the new interface
There is a new look for Office Excel 2007, a new user interface (UI) that replaces menus, toolbars, and most of the task panes from previous versions of Excel with a single mechanism that is simple and apparent. The new user interface is designed to help you be more productive in Excel, more easily find the right features for various tasks, discover new functionality, and be more efficient.
The New Interface commands hierarchy:
1. Menu Tabs.
2. Ribbons.
3. Groups within each tab break a task into subtasks.
4. Command buttons (icons) in each group carry out a command or display a menu of commands.
Ribbon user interface: The primary replacement for menus and toolbars in Office Excel 2007 is the Ribbon. Designed for easy browsing, the Ribbon consists of tabs that are organized around specific scenarios or objects. The controls on each tab are further organized into several groups. The Ribbon can host richer content than menus and toolbars can, including buttons, galleries, and dialog box content.
Tabs that appear only when you need them: In addition to the standard set of tabs that you see on the Ribbon whenever you start Office Excel 2007, there are two other kinds of tabs, which appear in the interface and are useful for the type of task you are currently performing.
Contextual tools: Contextual tools enable you to work with an object that you select on the page, such as a table, a picture, or a drawing. When you click the object, the pertinent set of contextual tabs appears in an accent color next to the standard tabs.
Program tabs: Program tabs replace the standard set of tabs when you switch to certain authoring modes or views, including Print Preview.
File Button : This button is located in the upper-left corner of the Excel window and opens the menu shown here:

Quick Access Toolbar: The Quick Access Toolbar is located by default at the top of the Excel window and provides quick access to tools that you use frequently. You can customize the Quick Access Toolbar by adding commands to it.
Adding Commands to Quick Access Toolbar: In the Customize Quick Access Toolbar box, select either For all documents (as a default) or a specific document.
Click the command that you want to add, and then click Add.

Dialog Box Launchers: Dialog Box Launchers are small icons that appear in some groups. Clicking a Dialog Box Launcher opens a related dialog box or a task pane, providing more options related to that group.

Use the Keyboard to Access any Commands in the Ribbon
To use keyboard shortcut: To open a menu tab, press the Alt tab, now press a letter(s) or a number or a combination of a letter & a number , see below:
Step 1: press the Alt key or F10.
Step 2:
Press H, and then a letter(s) or a number or a combination of both (a letter & a number).
Or
Use the Tab key to move between command buttons in the Ribbon.
Memory management, Workbook, Worksheet & Cells
Memory Management
Memory management has been increased from 1 GB of memory in Microsoft Office Excel 2003 to 2 GB in Office Excel 2007.
You will also experience faster calculations in large, formula-intensive worksheets because Office Excel 2007 supports dual-processors and multithreaded chipsets.
Numbers of Rows, Columns & Cells in a Worksheet
Excel 2007 sheet contains 1,048,576 rows by 16,384 columns, total of 17,180,033,024 cells compare to previous Excel versions which hold 65,536 rows by 256 columns, total of 16,777,216 cells.
New file formats
XML-based file format: In 2007 Microsoft Office system, Microsoft is introducing new files formats for Word, Excel, and PowerPoint, known as the Microsoft Office Open XML formats. These new file formats facilitate integration with external data sources, and also offer reduced file sizes and improved data recovery. In Excel 2007, the default format for an Excel workbook is the Office Excel 2007 XML-based file format (.xlsx). Other available XML-based formats are the Excel 2007 XML-based and macro-enabled file format (.xlsm), the Excel 2007 file format for an Excel template (.xltx), and the Excel 2007 macro-enabled file format for an Excel template (.xltm).
Themes, Colors & Formatting
Office themes
In Office Excel 2007, you can quickly format the data in your worksheet by applying a theme and by using a specific style. Themes can be shared across other 2007 Office release applications, such as Microsoft Office Word and Microsoft Office PowerPoint, while styles are designed to change the format of Excel-specific items, such as Excel tables, charts, PivotTables, shapes, or diagrams.
Number of Colors
Excel 2007 supports up to 16 million colors.
Rich conditional formatting
You can implement and manage multiple Conditional Formatting rules that apply rich visual formatting in the form of gradient colors, data bars, and icon sets to data that meets those rules. Conditional formats are also easy to apply in just a few clicks, you can see relationships in your data that you can use for your analysis purposes.
Formulas & Functions
Easy formula writing
Resizable formula bar: The formula bar automatically resizes to accommodate long, complex formulas, which prevents the formulas from covering other data in your worksheet. You can also write longer formulas with more levels of nesting than you could in earlier versions of Excel.
Function AutoComplete: With Function AutoComplete, you can quickly write the proper formula syntax. From easily detecting the functions that you want to use, to getting help completing the formula arguments, you will be able to get formulas right the first time and every time.
Easy access to Named ranges: By using Name manager, you can organize, update, and manage multiple Named ranges in a central location, which helps all users who need to work on your worksheet interpret its formulas and data.
New Functions
Very important and useful functions are added to Excel 2007. The functions are IFERROR, AVERAGEIF, AVERAGEIFS, SUMIFS and COUNTIFS. Read more and see example in Chapter 9, page 155.
New OLAP formulas and cube functions
When you work with multidimensional databases (such as SQL Server Analysis Services) in Excel 2007, you can use OLAP formulas to build complex, free form, OLAP data bound reports. New cube functions are used to extract OLAP data (sets and values) from Analysis Services and display it in a cell. OLAP formulas can be generated when you convert PivotTable formulas to cell formulas or when you use AutoComplete for cube function arguments when you type formulas.
Charts
A New look of charts
You can use new charting tools to easily create professional-looking charts that communicate information effectively. Based on the theme that is applied to your workbook, the new, up-to-date look for charts includes special effects, such as 3-D, transparency, and soft shadows.
The new user interface makes it easy to explore the available chart types so that you can create the right chart for your data. Numerous predefined chart styles and layouts are provided so that you can quickly apply a good-looking format and include the details that you want in your chart.
Visual chart element pickers: Beside the quick layouts and quick formats, you can now use the new user interface to quickly change any element of the chart to best present your data. In a few clicks, you can add or remove titles, legends, data labels, trendlines, and other chart elements.
A modern look with OfficeArt: Since charts in Excel 2007 are drawn with OfficeArt, almost everything you can do to an OfficeArt shape can also be done to a chart and its elements. For example, you can add a soft shadow or a bevel effect to make an element to stand out or use transparency to make elements visible that are partially hidden in a chart layout. You can also use realistic 3-D effects.
Clear lines and fonts: Lines in charts appear less jagged, and ClearType fonts are used for text to improve readability.
More colors than ever: You can easily choose from the predefined theme colors and vary their color intensity. For more control, you can also add your own colors by choosing from 16 million colors in the Colors dialog box.
Chart templates: Saving your favorite charts as a chart template is much easier in the new user interface.
Shared charting
Using Excel charts in other applications: In Excel 2007, charting is shared between Excel, Word, and PowerPoint. Rather than using the charting features that are provided by Microsoft Graph, Word and PowerPoint now incorporate the powerful charting features of Excel. Since an Excel worksheet is used as the chart data sheet for Word and PowerPoint charts, shared charting provides the rich functionality of Excel, including the use of formulas, filtering, sorting, and the ability to link a chart to external data sources, such as Microsoft SQL Server and Analysis Services (OLAP), for up-to-date information in your chart. The Excel worksheet that contains the data of your chart can be stored in your Word document or PowerPoint presentation, or in a separate file to reduce the size of your documents.
Copying charts to other applications: Charts can be easily copied and pasted between documents or from one application to another. When you copy a chart from Excel to Word or PowerPoint, it automatically changes to match the Word document or PowerPoint presentation, but you can also retain the Excel chart format. The Excel worksheet data can be embedded in the Word document or PowerPoint presentation, but you can also leave it in the Excel source file.
Animating charts in PowerPoint: In PowerPoint, you can more easily use animation to emphasize data in an Excel-based chart. You can animate the entire chart or the legend entry and axis labels. In a column chart, you can even animate individual columns to better illustrate a specific point. Animation features are easier to find and give you much more control. For example, you can make changes to individual animation steps, and use more animation effects.
Sorting, Filtering & Tables
Improved sorting and filtering
You can now sort data by color and by more than 3 (and up to 64) levels. You can also filter data by color or by dates, display more than 1000 items in the AutoFilter dropdown list, select multiple items to filter, and filter data in PivotTables.
Excel table enhancements
You can use the new user interface to quickly create, format, and expand an Excel table (known as an Excel list in Excel 2003) to organize the data on your worksheet so that its much easier to work with.
PivotTables
Easy-to-use PivotTables
By using the new PivotTable user interface, the information that you want to view about your data is just a few clicks away. You no longer have to drag data to drop zones that arent always an easy target. Instead, you can simply select the fields that you want to see in a new PivotTable field list.
After you create a PivotTable, you can take advantage of many other new or improved features to summarize, analyze, and format your PivotTable data.
Sharing & Connections
New ways to share your work
Using Excel Services to share your work: If you have access to Excel Services, you can use it to share your Office Excel 2007 worksheet data with other users, such as executives and other stakeholders in your organization. In Excel 2007, you can save a workbook to Excel Services and specify the worksheet data that you want other people to see. In a browser (browser: Software that interprets HTML files, formats them into Web pages, and displays them. A Web browser, such as Microsoft Internet Explorer, can follow hyperlinks, transfer files, and play sound or video files that are embedded in Web pages.), they can then use Microsoft Office Excel Web Access to view, analyze, print, and extract this worksheet data. They can also create a static snapshot of the data at regular intervals or on demand. Excel Web Access makes it easy to perform activities, such as scrolling, filtering, sorting, viewing charts, and using drill-down in PivotTables. You can also connect the Excel Web Access Web Part to other Web Parts to display data in alternative ways. And with the right permissions, Excel Web Access users can open a workbook in Excel 2007 so that they can use the full power of Excel to analyze and work with the data on their own computers if they have Excel installed.
Using this method to share your work ensures that other users have access to one version of the data in one location, which you can keep current with the latest details. If you need other users, such as team members, to supply you with comments and updated information, you may want to share a workbook the same way.
Quick connections to external data
You no longer need to know the server or database names of corporate data sources. Instead, you can use Quick Launch to select from a list of data sources that your administrator or workgroup expert has made available for you. A connection manager in Excel allows you to view all connections in a workbook and make it easier to reuse a connection or to substitute a connection with another user.
Printing
Better printing experience
Page Layout View: In addition to the Normal view and Page Break Preview view, Excel 2007 provides a Page Layout View. You can use this view to create a worksheet while keeping an eye on how it will look in printed format. In this view, you can work with page headers, footers, and margin settings right in the worksheet, and place objects, such as charts or shapes, exactly where you want them to be. You also have easy access to all page setup options on the Page Layout tab in the new user interface so that you can quickly specify options, such as page orientation. Its easy to see what will be printed on every page, which will help you avoid multiple printing attempts and truncated data in printouts.
Saving to PDF and XPS format: Like other 2007 Office release applications, Excel 2007 supports saving a workbook to a high-fidelity fixed file format, such as Portable Document Format (PDF) or XML Paper Specification (XPS) format, that encapsulates how it will look when it is printed. This allows you to share the content of your workbook in a format that is easy for other people to view online or print, without including the underlying formulas, external data queries, or comments.
Actually, this is what you did in earlier versions of Excel to collect the information you need before you save it to Excel Services.
Using Document Management Server: Excel Services can be integrated with Document Management Server to create a validation process around new Excel reports and workbook calculation workflow actions, such as a cell-based notification or a workflow process based on a complex Excel calculation. You can also use Document Management Server to schedule nightly recalculation of a complex workbook model.

Hi there

We work in Excel 2007 and have to save a document back to 97-03 for others to view.

When we do so, the file size increases to 6MB (from about 1MB).

Is this a known issue (a quick google search didn't find anything) or is there a way we can do it without the massive jump in file size?

Cheers
Griffo

Hello

All of a sudden Excel has stopped asking me whether I wish to save the file when I try and close it. I know it's a bad habit but I tend to just click close and save the file when prompted.

I've made sure that Application.DisplayAlerts is set to true but it doesn't seem to be making any difference.

Does anyone know of other settings I can check?

thanks

Richie

My worksheet has several rows of data and I am trying to use the autosum tool
in the ribbon it is not consistant, sometimes it will calculate the sum and
other times it puts the formula in the where the sum should be. If I use the
copy function from one that worked and paste into one that didn't it
magically returns a result. Why won't the autosum work?

1) Some of your cells are formatted as text.
Some of these worksheets were created in Excel 2003 and the data
did not retain it's format when opened in Excel 2007. Is there something one
can do to a file in 2003 prior to opening in 2007 to make it retain it's
former data types?

2) You have calculation set to manual. In previous versions this could be
found at Tools>Options>Calculations Tab.

In Excel 2007 the default is Automatic

I like the way that Excel 2007 handles conditional formatting for
overlapping ranges and such, but sometimes I have to save files
in .xls format. Invariably I get a warning that the conditional
formatting will not render correctly in older versions of Excel.

Is there a version of "Paste Values" for conditional formats that
applies the formatting directly to the cells? It would not longer keep
up with changes, but for presentation purposes it would work just
fine.

For example, I have a table of about 2200 rows by 50 columns. Going
down a particular column, most of the cells are zero, and the nonzero
values tend to occur in clumps. Using number formatting 0.0_);(0.0);;@
I blanked out the zero values. Using conditional formatting, I was
able to highlight the first cell of a cluster one color, the middle
cells a second color, and the last cell (before going back to zero) a
third color. I also have some conditional formatting that marks
certain rows, and lots of other stuff going on to help with data
visualization. In all there are 8 conditional formats, and it looks
just the way I want it to look.

I'd like to be able to save this as an Excel 2003 file and keep the
formatting. I know that Excel 2003 can't handle all these conditions,
but I would like a way of just applying the formatting-as-displayed to
the cells before saving. Something analogous to how "Paste Values"
will give you the value-as-displayed without the underlying formula.

Thanks!

Hi,

I am working on this Excel file that has hyperlinks and some small
macro. I used hyperlinks to jump from one sheet to another, and the
file didn't have any volatile function. We post the file onto the
sharepoint and set the sharepoint permission to "Read Only". when we
open the file directly from the sharepoint and try to navigate around,
the file kept on asking us to save changes every time we click on the
hyperlinks; even though we didn't make any changes. I couldn't figure
out whether there is a problem with Sharepoint or with the Excel File
itself. Please let me know if you have any idea.

I hope I asked this in the right group, if not, please point me in the
right
direction.

Thanks,
Tim

Hi,

I am working on this Excel file that has hyperlinks and some small
macro. I used hyperlinks to jump from one sheet to another, and the
file didn't have any volatile function. We post the file onto the
sharepoint and set the sharepoint permission to "Read Only". when we
open the file directly from the sharepoint and try to navigate around,
the file kept on asking us to save changes every time we click on the
hyperlinks; even though we didn't make any changes. I couldn't figure
out whether there is a problem with Sharepoint or with the Excel File
itself. Please let me know if you have any idea.

I hope I asked this in the right group, if not, please point me in the
right
direction.

Thanks,
Tim

Frnds,

Am facing trouble executing a macro in excel 2007. The macro is running fine in 2003, but crashes excel 2007 when executing the activeworkbook.close command. below is the code.

Sub CreateUpdateFiles()

Dim FilePath As String
Dim FileN As String
Dim CurrentCode As String
Dim WB As Workbook

Dim i As Integer
Dim z As Integer

Set WB = Excel.ActiveWorkbook

On Error GoTo NextItem

Application.ScreenUpdating = False

'Position cursor on first target
Range("A12").Select

'Define variants
'Count # of files to create
If Range("A14").Value = "" Then
   z = 1
   Else
   z = Range("A13", Selection.End(xlDown)).Count
   End If
   
   FilePath = Range("B9").Value
   FileN = ""

i = 1

 Sheets("Data").Range("k6").Value = Now()
   
' Start the creation OR Update
For i = 1 To z
    Selection.Offset(1, 0).Select
    If Selection.Value <> "" Then
        'Assign Code value to summary sheet for code execution
        CurrentCode = Selection.Value
             
        'Set the file name
        FileN = FilePath & CurrentCode & ".xls"
        'Check and open if exist the latest file created

        'CHECK EXISTANCE OF A PREVIOUS UPDATE ON THE PROJECT
        If Dir(FileN) <> "" Then

         Workbooks.Open FileN, False, False
         'Run Macro for updating the actual data
         Application.Run "'" & ActiveWorkbook.Name & "'" & ("!SummaryLink")

         WB.Activate
         Selection.Offset(0, 3).Value = "Existing"
         Selection.Offset(0, 1).Value = "Updated"
         WB.Save
         Excel.Workbooks(CurrentCode & ".xls").Activate
          
        Else
        
         'Open new workbook from template
         Workbooks.Open Range("B5").Value & Range("B7").Value, False, True
         'Save the document with the Project Name And month
         ActiveWorkbook.SaveAs FileN, xlWorkbookNormal
         'Enter the project code to update the workbook
         Sheets("Summary").Range("A1").Value = CurrentCode
         'Run Macro for updating the data
         Application.Run "'" & ActiveWorkbook.Name & "'" & ("!Update")
         'Run Macro for updating the actual data
         Application.Run "'" & ActiveWorkbook.Name & "'" & ("!SummaryLink")
         ActiveWorkbook.Save
         
        WB.Activate
        Selection.Offset(0, 1).Value = "Created"
        WB.Save
        Excel.Workbooks(CurrentCode & ".xls").Activate
         
         
        End If
        
        'Save the document with the Project Name And month
              ActiveWorkbook.Save
        'Reposition the cursor on the page
        ActiveWorkbook.Close savechanges:=True    'THE MACRO RUNS FINE UNTIL THIS POINT AND CRASHES WHILE EXECUTING THIS
COMMAND    End If
    ' Log result

NextItem:
    WB.Activate
Next i
    WB.Activate
Application.ScreenUpdating = True
    
End Sub


I am using Excel 2007. I want to save the file as txt with delimiters of , and " and of course a CR.

I have tried every choice possible with Save As and when I open in notepad it only will put a tab between each field. Does anyone know how to change the delimiter to a , and a " ?

Thanks for any help.

I can't import into my other application without the proper delimiters.

I am supressing an alert in Excel 97 saying that the file being saved was created in a later version. Unfortunately, the default answer is "no" to this alert so the program is silently not saving work. How can I combine "Application.DisplayAlerts = False" with a default to save the work? Thanks.

Hi All ,

I have create a excel which is link to many sub excel file , when i open the first file , and also open the sub file , which is hyper link , i just open the file to check information , i never edit the data.

when i want to close the file , it ask me want to file save ? i need to type no.

i not understand is i never modify the file , why excel ask me want to save the file ?

How to aviod these msg ?

Paul

Why excel 2007 didn't support dbase, excel 3.0, excel 4.0 and others file
type as excel 2003?
Since the excel 2007 didn't support dbase file type, what can i do if I want
save the dbase file type?

This is a minor annoyance at best as it adds unnecessary mouse-clicks every
time I try to open an existing spreadsheet unless the Excel application is
already running.

I've recently upgraded to Excel 2007--I never had this issue with 2003. When
I open an existing spreadsheet, the application opens but the file does not
come up. If I click on the RIBBON, the spreadsheet appears as if it were
hidden; if I click on another window or ALT+TAB back and forth, the
spreadsheet appears. If Excel 2007 is already running when I open on a
spreadsheet it comes up fine.

I've gone through the Excel Options menus but have found nothing that might
refer to this issue. Any assistance you can provide on this would be greatly
appreciated!


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