Excel 2000 to Excel 2002 problem
I have put a spreadsheet together using Excel 2000. A friend is trying to use
it with Excel 2002 and experiences a problem that I cannot reproduce in Excel
Cell E3 is a persons name. Cell F3 contains the formula '=E3' to auto fill
the cell. (If the name is not the correct one it is overwritten)
If friend copies the formula in F3 to F4 it copies the formula as an
absolute so that it is looking at E3 rather than E4.
He is not copying an absolute. He either drags the formula down or copy &
I can't understand what is happening but presume that his version works...micr configurable stubs
Has anyone had to configure checks for GP using configurable stubs for
MICR? Are there any tricks to making the process easier or an
alternative program to use. Th eprocess so far is painfull as only one
item can be selected at a time and each time I add an item it starts
in upper left hand corner above other items.
Thanks in advance for any insight
Are you using Mekorma? I've used it to configure checks and found it
relatively easy to use.
MCP-GP, MCT, MVP
East Coast Dynamics
get your GPtip42today at www.gp2t...excel file to cd-r is read only
oops - got the wrong key - ? is in the entry above. thanks, especially if
you answer the ? above - I'm pretty new at this, but I'm working at it.
Use windows explorer to copy it back to your harddrive (or network drive).
Then rightclick on it (still in Windows explorer) and choose Properties.
Uncheck the readonly attribute.
> oops - got the wrong key - ? is in the entry above. thanks, especially if
> you answer the ? above - I'm pretty new at this, but I'm working at it.
> "kzas&qu...From SQLite to Excel with ODBC-driver
I would like to access from Excel 2003 (OS: Windows XP) to a SQLite-Database
I did the following steps:
1.) Install SQLite-ODBC-driver:
From http://www.ch-werner.de/sqliteodbc/ I downloaded the file
"sqliteodbc.exe" which installs the ODBC-driver on my computer. I saw after
the installation on the "ODBC-datasources/System-DSN"-menu three new entries
("SQLite Datasource", "SQLite UTF-8 Datasource" und "SQLite3 Datasource").
2.) Create an SQLite-database:
From http://sourceforge.net/projects/sqlitebrowser/ ...Configuration
I just installed Office 7 Home and Student and every time I open Word it
says that it has to Configure the program. It doesn't do that with the other
programs and it is getting tiresome because it takes a few minutes. Has
anyone else had this problem or have some suggestions? Thanks!
...What is activating excel?
I need a way to tell if excel is being open from the start menu.
Or if excel is being started from a excel file icon.
Thanks in advance.
Try asking in an Excel forum. This forum is for Outlook programming issues.
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
"AK_Help" <AKHelp@discussions.microsoft.com> wrote in message
>I need a way to tell if excel is being open fr...Best book to learn excel?
I have found myself in a spot where I need to create a spreadsheet to track
and calculate totals ( payroll of sorts) for a department at work. But I
thought I would give it as shot myself. So I need to find the best book to
try to learn the basics. Is on of the "for dummies" publications the best
place to start?
This is for an industry where tips are a large portion of the income for
these employees and they need to be able to keep accurate records of what
they have made along with deductions for taxes, 401k health insurance etc.
They need a spreadsheet which they can keep on ...CRM 4.0 Outlook Client Install/Configuration
I cannot get the Outlook client to configure for any users. The
intranet address and internet address are not found. Connectivity has
been verified between workstations and crm server. Web clients work
ok - thoush some functionality related to custom entities is not
behaving properly (lookups not functioning, etc.)
Addtionally, CRM is not sending or tracking emails at all.
The CRM setup is as follows:
Upgraded from 3.0
Win 2K3 Server (fully updated) with SQL 2005 SP2, Reporting Services
Exchange 2003 Server (fully updated) - Email router will not
Any suggestions would b...BIFF5 (Excel 5) 255 char limit
I'm generating excel documents via PHP, and am running into a wall
with the 255 character limit for a cell in Excel 5 (the format the
script exports in). Is there any way around this?
If your program outputs to Excel 5 with 255 limit you might find out if the
manufacturer of that program allows output to a later file type. I don't
know PHP, and Excel can't control how that program outputs. You might try
copy and paste directly from the original program into a later version of
> I'm generating excel ...Color palette in Excel 2007
When I create a diagram in Excel 2007 the autofill colors are not the same as
the color palette I have made. The program takes a similar color but makes it
a bit dirty. Does anyone know how to make Excel pick the original colours (my
theme colors) by default?
...Excel XP automatic equals sign when formula bar clicked
In Excel 2000, you could click on a cell, then click on the
formula bar and an equals sign would pop up in anticipation
of a formula to be written. How can you make Excel 2002
duplicate this behavior?
This was removed from Excel 2002 onwards.
The closest you'll get is:
View > Toolbars > Customize
Under the Insert list you'll find "="
Drag it to a toolbar near the formula bar.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
I just started a 3 week trip and need to run Money to track spending while
However, when I start Money, it is trying to install something, and wants
the Money CD, which is back at home. Yes, I know I should have tried this
before I left, but the laptop with Money hasn't changed - its just out of
its docking station.
I thought I'd ask on the small chance that someone might have a clue on
what might cause this and/or how to get around it. I can't think of any
reason for something to be installed, but there must be something.
What file(s) is it asking for...email from excel to otlk 2003
Have upgraded to outlook 2003 after server upgrade sbs2003. OS is XP. Now cannot email worksheet direct from Excel 2000. Full attachment still ok but sometimes just want to send part, not whole.
You must be using the same version of Outlook and other Office programs for
full integration to work.
What happens if you select a range of cells, then copy/paste them into
Outlook? What message format are you using for Outlook? I know you can't
use Word 2000.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent t...Running an Excel Macro from an Access Command Button
Can anyone help me with this, I am trying to run an excel macro from an
access command button.
I want the macro to Bold the Headings on a excel spreadsheet.
The code runs without any errors but the macro doesnt seem to work, I think
I have got the line
ExcelApp.ExecuteExcel4Macro "RUN(""PERSONAL.XLS!BoldHead"")" wrong
Private Sub cmdRunMac_Click()
Dim ExcelApp As Excel.Application
Dim ExcelBook As Excel.Workbook
Set ExcelApp = Excel.Application
ExcelApp.Visible = True
Set ExcelBook = ExcelApp.Workbooks.Open("C:\Documents and
Settings\...Where is Excel.h?
I just looked at KB article Q178749 and followed all the steps.
Where in the world do you get Excel.h from? I searched my whole PC and this
file was not found (I have Office 2003 installed). There aren't too many
search results from people that have had this problem, so I'm missing
Does anyone know where I can find excel.h?
Thanks in advance!
I would guess that this file would be generated when you import the
type library. Did you try importing it as mentioned in steps 8-10 of
Well I...2003 excel
I would like to change the cell color if there is a "r" found in it. All the
cells are in the same colum and there are also numbers in the cells with the
"r". Can anyone help ?
Assume data in col A
Select the col, then apply conditional formatting
using Formula Is:
Format to taste > OK out
Replace SEARCH with FIND if you need it to be case sensitive
Downloads:16,400 Files:356 Subscribers:53
> I would like to change the cell color if ...Converting Excel to HTML... overwriting rows in Explorer?
I've created a table within Excel 2000, and have saved it
as an HTML page. When I view it in Explorer 6.0, it
appears as if some of the rows are overwriting onto each
other (for instance, row 14 and row 15 are in the same
cells). If I hit reload, these rows may appear normal,
but the same error occurs further down the page.
Any help would be much appreciated,
...Is it possible to set MS Excel 2K to display in UTF-8 like Intern.
I am trying to open a CSV file that contains Japanese Chars in UTF-8 with
excel 2000. When I do open the file, the chars seem to be interpreted in
shift-JIS. Is there any way to set excel to view in UTF-8 so that my
characters are displayed correctly?
...How to create Release mode configure
i am building a project, but i removed default Release configure, and now i
try to use Debug config to copy to Release and then change something NDEBUG,
Debug info is none, uncheck Generate Debug info
any one can help me do this so that i dn't need to create new project again?
Turn on optimizations. Do NOT turn off "Generate debug info"; it was a fundamental design
error in VS to turn this off. You will need it to read crash dumps coming back from the
field. Turn off the various runtime checks. Select the libraries to be the MultiThreaded
DLL or for static lin...Excel and Metastock
Does anyone know how I can import MetaStock data directly into Excel
without using Downloader?
Any help here would be appreciated.
Whwnever I start Windows, Office tries to reconfigure Publisher - how do I
What version Publisher?
You receive a "Please wait while Windows configures Microsoft Office XP Pro"
error message when you upgrade to Office 2003 or Office 2007
Mary Sauer MSFT MVP
"BG" <BG@discussions.microsoft.com> wrote in message
> Whwnever I start Windows, Office tries to reconfigure...translate number in dollars to wording in excel 2003
especially when entering currency together with the wording so if that can be
done that speed up data entry
'How to convert a numeric value into English words in Excel'
If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:
"Jimmy" <Jimmy@discussions.microsoft.com> wrote in message
I need to allow my users to retrieve their mail from my Exchange server while
they are away from the office. I have OWA working right now for web-based
email, but I am considering stopping that and only using IMAP4 because many
of my users have only dial-up access at their homes, and it takes too long
for them to connect via OWA. The main people complaining about the currect
situation are the executive director and program director, so I'd like to do
what I can to keep them happy. However, I need to know how to access the
Exchange mailboxes from outside the network. I have tried sev...how to open a pdf file in excel file
Try to open a pdf file in excel by using hyperlink. I assigned a link it
seems pdf program is opened by shut down right away. Anyone know?
...How do I configure a reminder for attachment passwords?
My company sends attachments (office files) to clients via
the internet. They usually password protect these files.
Is there anyway to have outlook tell the user that the
attachment does not have a password? Sometimes they forget
to put the password on the attachment...
You would have to write code to do that. Your code would have to
intercept the AttachmentAdd event for an open item, check the original
item that is being attached by opening it from the file system as a
file of the specified type, for example Word doc. Then it would have
to use the Word object model to chec...