Change links to hyperlinks in a workbook?
I have 5 Income Statement sheets in a workbook. The first sheet is an Income
Statement summing four departments (listed by columns). Column B has Dept 1
data, column C has Dept 2 data, etc. ALL data on this sheet is linked
(referenced) to the other four sheets which are the individual departments.
I know I can set hyperlinks one at a time, but is there a way for me to have
each of those links (every cell containing the data from the other four
sheets) become hyperlinks?
If I have to add another sheet that mirrors the summary sheet but has
hyperlinks, that would be fine. I am just ...Change <value> in outlook
We Have Exchange 2003 sp2 and outlook 2003 sp2. I have renamed 2 AD
accounts. Changed all display names, accounts name etc with the 2 accounts.
When users open outlook and send to renamed account they see account name
<oldaccountname> in the autocomplete list. I have cleared nk2 files in
profile , but it still shows newaccount <oldaccountname> in drop down box. Is
there a way to edit the <oldaccountnam> value of the renamed account? I
tried the same thing with a freshly loaded PC. with the same result.
You can delete the nickname files.
MVP - E...Change of recipient/sender display name
Environment :- Windows 2003 x64 with exchange 2007 (All in one role)
Outlook client :- 2003, 2007
We have created a list of mail contacts (which under GAL) in exchange
2007, these mail contacts are associates with external email address,
each of contact has a naming standard for display name, for example,
display name is HD Finance Manager, external email address is
I want to configure outlook client to show the display name according
to mail contacts whenever the email address is match to mail contacts
list (GAL), for example, an email sent from the email a...changing the cell information #2
Hi I have files I tried to change the cell information to another cel
that have to be the blank for a row that contains director name in cel
A and for the movie titles I have to have director names instead of th
title names.Please help me, the data in cell B sholuld have to be,
2 T:Back to the future
5 D:Adam Mathew
6 D:Adam Mathew
7 D:Adam Mathew
Message posted from http://www.ExcelForum.com
...Change default font format in Excel
I have an existing workbook with cell text entries in regular black font. I
want to make a number of additional entries in various cells in this
workbook, and I want all my text entries to be a different font format (bold,
red). Is there a way to do this automatically without highlighting each
entry I make and manually changing the cell format? Thanks.
Copy the code below, right-click on your sheet tab, select "View Code" and paste the code in the
window that appears.
MS Excel MVP
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Cou...Linked graphics into a Publisher 2000 document
I have a 400KB document (withgout graphics). I insert two
JPEG images each around 200KB into the document. I figure
the resulting document should be around 700KB. Result? An
I delete the images (document is now 400KB) and instead
insert the images using the "Link to File" option.
Graphics Manager confirms that the images are linbked into
the file. The size should not be more than 500KB. Result?
An 11MB file.
Question is how can I insert images into a Publisher 2000
documentr without the file blowing up? And why does it
Richard wrot...Changing Interface OWA (exchange 2003)
Not sure if you all remember but back in the Exchange 5.5 days we use to be
able to go onto a site and put in the username of the person mailbox you
want to access, then a windows pop up would come up asking you for your
credentials. I was wondering if that is still possible to do that in
Exchange 2003? If so how can that be done?
Configure Forms-Based Authentication (FBA).
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"John" <email@example.com> wrote in message
> Not sure...Change License / Company name
we tried CRM 1.2 with the MSDN license key. Now my company bought a 25 user
Proffesional Suite license and I want to change the key on the production
server. Is there an easy way to do this??
The only solution I see, is via the Data Migration Framework.
How about the re-deploy tool?
"Erik" <none> wrote in message news:u0SXdbXlEHA.3452@TK2MSFTNGP15.phx.gbl...
> we tried CRM 1.2 with the MSDN license key. Now my company bought a 25
> Proffesional Suite license and I want to change the key on the production
> server. Is there an easy wa...gp10 change clients pointing to different server
In version GP 10 I have clients pointed to a test server. When production
server is ready what do i do to point the clients to the production server
Would I change the odbc connection?
Rerun the client installs?
Any help is appriciated.
As long as your production server has THE SAME level service pack as your
clients and THE SAME third party products all you need to do is repoint your
ODBC to the production server.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
"2020" wro...Changing the Selection Fields in a Combo Box
I've created a Combo Box using the Controls Wizard. In creating the
control, I specified that my unique value to be stored in the table is an ID.
When the user views the selection options in the Combo Box, I'd like to have
the ID field hidden and only see the text values, while still storing the ID
in the appropriate column.
This is probably a second question.
Also, when the user views a form that has been populated, I'd like them to
see the actual textual values on the form, as just the stored ID value. Is
that possible to do with the one Combo Box or is that...APAY Frequency changes mysteriously
Has anyone noticed that if, for example, you set up an APAY bill monthly,
that all of a sudden the next pay date is many months later?
It will be cruising along fine, sending bills monthly via MSN Billpay
automatically and then one day I go to look at BILLS AND DEPOSITS and some
of the autopay's that should be due next month say something crazy like it
wont be paid until three months from now or even Jan of next year. I have
to cancel the autopay and resubmit it with the proper information.
This has happened to me several times in Money2003 on XP...
p.s. I tried out the archive feature t...Background changes conditionally
I have a spreadsheet that shows the floor plan layout of my call
On each desk, the desk number and identity are displayed. I would like
to colour the background for those pcs that are on the same subnet.
I have a sheet called data - it contains Table Number, Desk Number, PC
ID, IP Address.
How could I get it to change the background colour if the pc is on
subnet 162, and set a different colour for those on subnet 167
PeterG's Profile: http://www.excelforum.com/member.p...Locking cell color while allowing data changes in cell
In excel 2000, I created an attendance worksheet for my
classes.(Alphabetized names down left vertical column. Dates across
top of horizontal row.) I added a different color to all cells in
every other row to make for easier reading of each student's name and
absences. Every other row stays with a white background.
My question: I wondered if it was possible to lock row colors while
allowing data to change on top of them. If a new student is added to
my class in alphabetical order, the alternating color pattern is often
lost. It is a pain to rechange row and cell colors.
Any shortcut ...OWA & "User must change password at next logon"
Current Environment: Running EX2K3(SP2), and using OWA as the ONLY option to
get e-mail; using certificates (https:\\owa.domain.com\exchange) & forms
Problem: I create a NEW user in AD; e-mail enable it, and select "User
must change password at next logon". Now when the user tries to log in (VIA
OWA) s/he is not prompted to change the password / it won't even log them in.
It use to work with our old exchange 2000 environment, where it gave them the
opportunity to change the password at sign on. Answer: ?
There is one property in MetaBase: ...Unicode "private use" glyphs in Powerpoint and Word 2008 #2
Office 18.104.22.168 on Leopard 10.5.2, all updates applied to both.
A friend is migrating from Windows to Mac, and has come across
something that we're trying to work around.
He has some .ppt files with font glyphs in from a Unicode .ttf font (a
specific purpose font for showing the LCD display characters on a
piece of monitoring equipment). When we bring the font and .ppt over
to the Mac, the glyphs from the normal ASCII range come over into
Powerpoint 2008 fine, but the glyphs from the "private use" range from
F000 upwards a way don't transfer. In Powerpoint they show as spac...Changing default Print copies
I have a workbook that has a worksheet with default printing copies of
3. Even when I go to page setup and change the number of copies to
print to 1 it will automatically revert to 3 the next time I bring up
the print dialog. I have also looked through the VBA editor at the
worksheet for any oddities and have found none. Does anyone know how
to change this permanently?
Thanks in advance.
>Even when I go to page setup and change the number of copies to
> print to 1 it will automatically revert to 3 the next time I bring up
> the print dialog.
Look at the defaults for you...stop automatically changing formula!
i have a countif function
when i copy this and paste it to the next cell, the formula automatically
change to COUNTIF(Locking!J16:J40,"f")
How do I stop it from changing column I to J?!?!?!
MS Excel MVP
"caryn" <firstname.lastname@example.org> wrote in message
> i have a countif function
> when i copy this and paste it to the nex...HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE
My cell c1 contains the formula b1-a1.when i copy this formula to cells d1
and e1 the cells d1 and e1 have the following formula :
but i want the following
d1 should be b2-a2 and
e2 should be b3-a3
how do i do this?
In C1 enter & copy across:
> My cell c1 contains the formula b1-a1.when i copy this formula to cells d1
> and e1 the cells d1 and e1 have the following formula :
> but i want the following
> d1 should be b2-...break links #2
Is it possible to break links between excel files to publisher files?
I have a chart that is linked into a publisher file, but i dont know how to
turn off the link. is it possible?
Copy the chart, paste special as an Enhanced Metafile, delete the linked chart.
"George" <George@discussions.microsoft.com> wrote in message
> Is it possible to break links between excel files to publisher files?
> I have a chart that is linked into a publisher file, but i dont k...unable to change password via OWA
I am having a problem with users changing passwords via OWA. When they click
on the change password button, it comes up with change password screen and
asked for domain name, user name , old password ,etc. The problem that I have
is that when I submit it, it comes up with message saying "Either the
password is too short or password uniqueness restrictions have not been met."
But I didn't define any password policy on DC.
What can I do ?
Kindly please give me some idea.
If you are running windows and exchange 2003 then there are password
requirements that...prompting to save workbook every time (even when no changes made)
i have 3 workbooks all very similar and every single time i open any o
them, even when not changing anything, i am prompted to save th
its so bad that i can literally open the workbook then click the clos
button straight away and it STILL prompts me to save it because i
seems to think something has changed.
as far as i can see i dont have any macros or anything that will ru
every time it starts and change something (i did have a = today in on
cell which kept the date as today but taking this out made n
Message posted from http://www.ExcelForum.com
You prob...find match then change cell value
In column A I have cells filled with text and in column B I have cells filled
with numbers. I need to check if the number in cell C1 equals any of the
numbers in column B. If a match is found then I need to change the text in
column A to CBO.
Column A Column B Column C
aep 5 7
Since the cell C1 = 7 equals the 7 from column B, I need to change the data
in column A from xle to cbo. Is this possible...Insert new row as cell contents change
Insert new row as cell contents change. After importing
data I have a spread sheet with a column that contains a
series of alpha numeric characters. At various random
intervals in this column the contents change. EG rows 1 to
4 could contain ABC, then rows 5 to 15 could become 222. I
am looking for a method to insert a blank row
automatically between the rows were the contents change.
If you are familiar with VBA the code below will do what you want.
Preselect the column of data first
Dim myCell As Range
Dim sCurrVal As String
How do i link my drop down list in a13 sheet 1 to column f in sheet 2.
if using Data Validation to create your drop down list the easiest way is to
range name column F in sheet 2
(go to sheet 2, click on F, click in name box (left hand side of formula
bar) type name (no spaces), press enter)
then click in Sheet1!A13, choose Data / Validation, choose List - click IN
the big white box, press you F3 key to bring up list of names in workbook,
choose the name, click OK, click OK again and it should work fine.
Hope this helps
"Jinx" <anonymous@discus...Link to Power Point
I placed a hyperlink to a powerpoint file on my web page. Upon clicking on
the link the "Run/Save" window comes up. Is it possible to just have the
Power Point file run without the "Run/Save" window coming up? If so, how?
Posting a question 4 times isn't going to get you an answer any quicker.
Try to be a bit more patient.
>I placed a hyperlink to a powerpoint file on my web page. Upon clicking on
>the link the "Run/Save" window comes up. Is it possible to just have the