I have just recently installed Office 2007 and expected over 1 milliion rows
to be displayed in Excel.
For whatever reason, only 65536 rows are being displayed

Does anyone have any VBA learning materials that are free or know of any? I
currently have no knowledge at all of VBA therefore need materials that will
go from the absolute basics to advanced level
Thanks in advance

i need to place data located in 2 columns in to 1 col seporated by a space.  
The rev of text to columns. If this is done with "consolidate" then i do not
understand how to do it.
example

If I have A100 in one cell, can I create a formula that would put "100" in
the next cell?  Thanks!

All,
How do I export my Excel as a pipe separated text file?
I'm not familiar with VBScript so if you're going to post such a
solution, please include a how-to so I know how to incorporate it into

I have about 800+ excel workbooks, with an apparent problem.  If I
open one of the files in excel 07 it gives me an error message, Name
Conflict
Name cannot be the same as a built-in name

Please can somebody tell me if and how can I "hide and lock" a column (or
row) with a password so that other people cannot see it, BUT without
preventing others to use feature like hide / display or group / ungroup on
other columns (or rows).

How can I re-open an Excel file when the error message says  "Name cannot be
the same as a built-in name" and it says that the old name is < Print_Name>.
I don't have any file with that name.

I have 2 Excel files, sitting in the same folder.  There is a formula in file
A that looks for a value in file B and updates file A accordingly.  The
formula works like a charm when users in my office open file A, select update
links, etc.  However, when 'remote' users attempt to ...

OMG!! How do i change a date from yyymmdd to show as mm/dd/yyyy?

In the Excel 2003 I used the Data filter feature to cut or remove selected
rows from my sheet.  The expected result the remains rows would remain in the
sheet as occurred with Excel 2003.
With Excel 2007, if I cut or remove the selected rows, when I uncheck the

Start at the bottom of the post and read up.  Any help is appreciated.
"Ramesh, MS-MVP" wrote:

I have a excel file, which reads from many other excel files (created
and updated by other users). I use Paste Links to read the data I need
from the source files but due to 255 character limit the text string
gets truncated after 255 characters. Does anyone know a workaround or

I want ot change the Default Font in Excel for all the installations in my
office. I've created already a new Map.xlt which can be placed on evry users
PC. But how to change the default font under Tools | Options for evry user?
Where are the options stored?

Hey all. Long story short, hard drive on my work laptop died, but I had a
backup. so I am transfering stuff back over, and I have my excel11.xlb file
and I put it where it should go, but the settings are not showing up in
excel. Any ideas?