Using Fill to Increment Cell References
In the first column of my spreadsheet (coumn A), every third row of my
spreadsheet contains information that needs to be linked to a different
location in my sheet. For example, A1, A4 and A7 contain the
information that needs to be referenced. In D1, I would like type
"=A1", in D2 I would like to type "=A4". Ideally, I would like to fill
down and have the cell references increment to A7, A10, etc. Is this
possible? Thank you for your suggestions.
Message posted from http://www.ExcelForum.com/
Type in the A1 and the A4 with out the equal signs. Select both, fi...Contacts not available as address book
I've just transferred my data files from a W98 PC to a
new stand-alone WXP PC (by temporarily installing the old
hard drive in the new PC and copying all the data files
over to a separate folder in the new hard drive). I then
copied outlook.pst (all 212MB) to C:\Documents and
Data\Microsoft\Outlook (where it has transmogrified
itself down to 135MB). The old version of Outlook was
2000, the new version is 2002.
Almost everything I have tried so far works fine, except
for the following problem.
When I try to use the address book, I g...How to, multiple contacts
How do I create a mailing list so I can send the same email to multiple
recipients at one time. I'd like to give the group a name and then just
choose it like I would any other person in my contacts folder.
I'm using Outlook 2000
1. Distribution Lists
2. Separate Contact Subfolders
The first is simple, easy and explained in any Help file. It's fine for
short list that you don't mind maintaining manually. DL's aren't reliable or
robust and have no features.
You can compare the other 2 choices (which most seasone...Trouble with the template.
I want to reset the 'normal' template to default to "Times
New Roman" 10point font, and the pages numbered centre top.
This seems to work when I set and reopen Word2003 from the
Administrator Template vis:
C:\Documents and Settings\Administrator\Application
But it will not work when I open Word2003 normally from the
I have deleted the "Normal.dot" from the following and
copied in the "Normal.dot" from the Administrator above:
C:\Documents and Settings\All Users\Application
Data\Microsoft\Templates...Auto correct the accidental use of cAPS LOCK. not working #2
I use OL2003 and have checked the box to auto correct the accidental
use of cAPS LOCK. This hasn't worked has become very annoying.I use
Outlook as the editor, not Word. OS is XPsp2
It is a Word feature so you must be using Word for this to work.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, swoffa asked:
| I use OL2003 and have checked the box to auto correct the accidental
| use of cAPS LOCK. This hasn't worked has be...Sharing calendar and Contacts
Hi!! I have the following scenario:
Two users are connected in different nodes with external internet accounts
(not exchange server) and want to share their calendar and contacts. Is this
possible? Is there some tool out there that enables them to view the
calendar and share it to both of them?
Thanks much in advance,
Options on sharing with Exchange can be found
"Teo" <email@example.com> wrote in message
> Hi!! I have the following scenario:
> Two users are connected in...Cant select contacts as address book
I have a user who has a local contacts folder with
contacts that they have added. When they try to create a
new message thier contacts folder is not available to
select from. If I go to the properties of the contacts
folder to check the box to "show this folder as an
address book" it is greyed out and will not allow you to
change it. The user has outlook 2003 and we are on an
exchange 2003 server. Any help would be appreciated.
Elbryyan <firstname.lastname@example.org> wrote:
> I have a user who has a local contacts folder with
> contacts that they have added. When th...After XP sp2 upgrade, Outlook 2003 crashes every time a Contact is saved or links to other contacts added to it
The subject line says it all. On my Toshiba Tablet PC, "After XP sp2
upgrade, Outlook 2003 crashes every time a Contact is saved or links
to other contacts added to it" (via the Contact's "Contacts..." link
button). The error signature is always the same:
AppName: outlook.exe AppVer: 11.0.6353.0 AppStamp:408f2937
ModName: mso.dll ModVer: 11.0.6360.0 ModStamp:40d147de
fDebug: 0 Offset: 0001f0e3d
And I always send a report to Microsoft (about 115K each), but there
is no response giving a fix as there sometimes is.
With www.Microsoft.com -> Windows Update, I ha...Email trouble with New User in Active Directory
Below is a trail of posts that have been made. My
problem has yet to resolved and I need some help
quickly. The only other thing I can think of is to
reinstall Exchange Server 2003. Hopefully someone will
know the answer.
Subject: Re: Email not Setup when new user created in
From: "Bryan Hill" <email@example.com> Sent:
8/15/2004 12:30:21 PM
We have other clients that are working fine. Just when
we try to set up new ones - it will create the SMTP
address but not the X400 address. I tried manually
forcing the X400 but it will...Outlook 2003 contacts
When you open an email and want to save the email address on the "From"
1. right click the address and save it to your contacts - Outlook will then
save it to your c:\drive profile
How does one go about having it saved to the network
\\network\publicfolders\contacts instead of the c:\drive
Setup: Windows 2003\Exchange 2003 - individual profiles and not saving
pst's on the c:\
We're already sharing a contacts folder on the public folders section. MS
forgot about allowing users the ability to save to it directly. I've
already checked Outlook 2007 and ...Windows Forms 2.0 #2
I have a complilation problem on a windows form in a Word VBA project.
I included Excel since it's one of those other languages that uses
Windows Forms instead of VBA forms.
Every time I open Word or Excel I get all these stupid prompts about
missing picture; compile problems; etc.
I can get into the VBA project-- which surprises me-- but I can't open
the Windows Form; since it sits there and complains about a 'missing
I double click on the form name in Project Explorer (in the VBA IDE)
and it just barfs and says 'cant find picture'.
it won't compile; ...using outlook and outlook express simultaneously
I use Win XP Home Edition SP2, Outlook 2003 and Outlook Express
Is there any problem running both Outlook and Outlook Express simultaneously
on same machine?
Is there any known problems from using two application simultaneously?
sn from Japan
No and no.
"snomazushi" <firstname.lastname@example.org> wrote in message
> I use Win XP Home Edition SP2, Outlook 2003 and Outlook Express
> Is there any problem running both Outlook and Outlook Express
> s...trouble with CrmIsapi.dll
I was experiencing the same problem with the SDK as many have posted
to this group ...
"the WhoAmI() call results in a http error 405 when running sample
I followed some of the advice; checked my .srf mapping to CrmIsapi.dll
and re-registered the CrmIsapi.dll.
when I re-register CrmIsapi.dll I get an error 80004005 - unspecified.
I copied it to various places and retried it ... same result.
I got the original from the disk and retried ... same result.
unmapped it from .srf, restarted and retried to register it ... same
Anyone experienced this.
What's up with m...unexpected conversion trouble
I wanted to open an Excel file I hadn't been working on for a while, an
Excel couldn't do it.
After some investigations, I found that even if the file still had th
.xls extension, it seemed to be conveted in .doc format (in fact, whe
I open it in notepad, I can see at the end some words that look like
MSWord signature). I don't know how this happened, but I'm reall
embarassed beacause i really need the data in this file.
I tried to change the extension to .doc, open the file in Word and the
import in Excel, but I can hardly see part of the file. What's more, i
is a 3-she...Trouble with Outlook 2003 and PST File
We have a user who is using Outlook 2003 and moves most emails to a PST file
which is considered archived email data.
They have reached the Max limited on this PST file of 1.99GBs and its not
letting them open the PST file.
It is trying to repair it when they try to open the PST file.
Here is the message they receive:
"Can't move the items. The file <path>\<filename>.pst has reached its
maximum size. To reduce the amount of data in this file, select some items
that you no longer need, and then permanently delete them."
I can't even get it open to delete...Publisher 2003-How does one learn how to use it?
I'm disgusted with Microsoft. I purchased Microsoft 2003
with digital imaging expecting to find manuals on how to
use the product. There was a manual for the digital
imaging, but none for Publisher. How does one learn how
to use Publisher, through osmosis?
Not including an operating manual is like going into a
restaurant and ordering your meal only to find out the
restaurant doesn't supply silverware.
Does anyone know ehere I can get a manual or training?
I appreciate your responses.
Ron strange you think Microsoft would care about what you think.
Ron Publisher up to version...Outlook Contacts #19
When I am trying to send emails, my Outlook (2003) is not recognizing
emails. When I click on "To" and look in my contact list, the emails are
listed, but Outlook isn't recognizing them like it usually does. Has anyone
else experienced this, and if so, please help! Thanks, Hillary
Hill <email@example.com> wrote:
> When I click on "To" and look in my contact list, the emails
> are listed, but Outlook isn't recognizing them like it usually does.
The "emails" are listed? Do you mean the addresses? What do you mean by
"Outlook i...Importing contacts from Lotus Notes
Operating System: Mac OS X 10.4 (Tiger)
How can I export my Lotus Notes Contacts and import them into my contacts in Entourage?
> How can I export my Lotus Notes Contacts and import them into my
> contacts in Entourage?
Entourage can import tab-delimited or comma-delimited text files for
Contacts. Look under File --> Import... You'll need to determine if you
can export your Contacts into one of these formats.
Hope this helps!
Entourage Help Page <http://entourage.mvps.org/>
...Trouble with Pivot Tables & Named Ranges
Can I use a dynamic named range setup in one file as a range in pivot tables
in another file?
When I have the data source file (with the named range) and the pivot report
files open, the pivot reports update just fine. But the moment I close the
source data, the pivot reports no longer can update and I get a message that
the source can't be found. If I reopen the source, the pivot tables work
fine again - but as soon as I close it up, the reports no longer work.
The source file is very large and I don't want to open it every time I have
to update all the reports tha...I am in trouble
I am a student in Cambodia.I don't have any girlfriend. I tried everything.
I looked at them wrote poem to them it doesnt work. I got an account from
facebook, hi5 friendster myspace. I have 0 girl friend. What should I do? I
am so desperate. I am good looking and 250 kg only. Please help me or at
least send me some foood I am hungry
__________ Information from ESET NOD32 Antivirus, version of virus signature database 4944 (20100314) __________
The message was checked by ESET NOD32 Antivirus.
You're tr...Business Contact Manager #36
I have Business contact mgr with outlook 2003, xp home on
a Compaq 2700T laptop. Loaded it once. Soon after my
battery died and killed the program. When I returned to
outlook, the two BCM menus were gone. I have reinstalled
outlook and BCM many times, but I can't get BCM (Business
Contact Manager) to load again. Can anyone help?
Go to the Control Panel and click on Mail. Add a new service and choose the
business contact manager.
"Tim Kirkland" <Tim@discussions.microsoft.com> wrote in message
news:76a701c48465$c52758...Sending contact "item" to others
If I send "John's" contact card as an item to "Mary", she receives it
blank/can't see anything NO ATTACHMENT DISPLAYS, as if I hadn't attached it
--which I knwo I did because of my "sent messages..."
The same thing happens if I send a distribution list. What could be the
issue? Is the problem when I send the card or when they receive it? How can I
Make sure you insert the Contact Record as an Outlook Item in an RTF message
and that neither of you uses email AV scanning.
"M" <M@discussions...Publisher 2000 and Windows XP
I recently installed my Publisher 2000 on my new computer that runs XP. It
worked fine for a while and now I can't see any pictures or clip art that I
insert. All I get is a box with a big X through it where the picture or clip
art is to be. I reinstalled, same thing. Any suggestions?
Try View, pictures, detailed display...
Mary Sauer MS MVP
"River" <River@discussions.microsoft.com> wrote in message
>I recently instal...Lost contacts, folders and messages after repair
I am running Outlook 2002 SP 2 on a fairly new Dell. I
was experiencing problems, so I ran the "Reapir" function
from the Microsoft Office installation disk. The repair
fixed the functionality of the program, but erased all my
e-mail messages, folders, address book and settings. I
was able to restore the settings and can access new email,
but all my old data is lost.
How can I restore my old address book, folders and saved
Check the properties of yr current Personal Folder, to checks its name &
Then Search, to include hidden files, for *.pst
If this f...Using a relative SHEET reference for source data in a chart
I have a workbook with sheet 1 containing data, and sheet 2 containing
charts based on the data in sheet 1. I want to be able to use these two
sheets as templates for new sheets in the same workbook like so:
sheet 1 data -------> sheet 2 chart
sheet 3 data -------> sheet 4 chart
sheet 5 data -------> sheet 6 chart
When I try to copy sheet 1 to sheet 3 all is well, but when I copy the
charts in sheet 2 to sheet 4, those charts source data is still gathered
from sheet 1.
I need a method to replace the "sheet reference" in the source data to refer