Problem removing hyperlinks in workbook
I am trying to remove all of the hyperlinks in my (giant 100 meg) work
book or any subset of the workbook, but everything I have tried has
I can right click on each cell and remove the link, but that will take
I tried the following:
1) Multiply a selection by 1. This does not work. I can multiply a
single cell by one, but if I do a selection, it does not work.
2)*This crashes my workbook*
3) *Again, this does not work if I select more than on cell at a time*
I have a spreadsheet that uses the following calculation:-
The problem i have is that while H2 is constant, H85 can change depending on
how many rows their are?
I am trying to use a terminating value such a 'end' so it knows that when i
reach 'end' it uses the previous row reference to replace what is currently
Is it possible?
Hope this makes sense.
Unfortunatley i've tried that, it distorts the figures as it tries to
calculate the % for the whole tabl...Another Macro Problem
I have another macro question. I have a macro that I have modified numerous
times, and now it works great, BUT I am having one problem.
I am using Data Validation to alphabetically sort three lists that I have on
the Lists sheet. On Sheet 1 cell I5 I either select a current vendor from
the list, or I add a new vendor to the list.
I tried using data validation and having this applied all the way down to
I can select the current info, but on the cells I6:I40 I can't add new info.
I can only add new vendors in the I5 Cell.
Below is a section of my macro. I think the problem is...File Name Problem
I created a spreadsheet in the usual way, when I use the spreadsheet the file
name adds a :2 following the name.xls. When I close the file the :2
disappear. This is not causing me any problems I've not seen this before and
curious if it's something I've done.
check <Window> and see if there is a "...xls:1"
you may just have two windows for the same file showing if you close one of
them and save the file the :2 should go away.
> I created a spreadsheet in the usual way, when I use the spreadsheet the file
> name ad...POP3 problem driving me crazy
The server (sbs 2003 pre) at work was configured to retrieve mail from
another mail server hosted by the IPS (can't change that due to multiple
anyway that was all working fine and dandy till last week when the
server decided to stop retrieving the mail, there were no changes made
that would affect it, and I was away from work for a few days, so when I
came in and was informed of the problem my first reaction was to try and
force an email retrieval by opening the pop3 connector manager and
telling it download now, but the properties for the pop3 connector
ma...Booklet Settings/print preview problem
I have created a booklet, but am having trouble with the settings. It is an
8 page booklet and everything looks great while working on it. When I go to
"print preview" it displays the booklet on one large sheet (instead of
showing two side by side like when I was working on it) and displaying only 1
and 1/4 pages that says it will print that way. When I used to hit "print
preview" at my old office/computer it would show the booklet pages (example
page 2 and 3) right next to eachother that looked just like what I was
working on in a PDF looking document (no...Distribution group problem
I have over 700 address contacts that have been "tagged"
into various categories. I know how to set up a new
distribution group. However, when I choose "select names"
the names from my list apear as first name, last name
instead of last name , first name. This makes it almost
impossible to scroll up and down looking for the name I
want to select and add to my distribution group. Please
advise of any suggestions.
In Outlook XP, select Tools, Options, then click Contact Options. Change the
Default File Order to Last, First.
"Randal" <randal.langley@...Email Tracking problems 10-05-07
I'm having problems with emailtracking. In general all mail tracks through
CRM but som mail encounters this error message:
the attachment i either not a valid type or is too large. it cannot be
uploaded or downloaded
There is a registry setting about setting the maximum attachment size. Log
on to your CRM server, and look at the following keys:
The keys can be found in HKLM\SOFTWARE\Microsoft\MSCRM
"Ivar A Hagen" wrote:
> I'm having prob...Problems with distribution groups in Exchange 2003
I have a small business server 2003 with SP1 for both windows and exchange
server installed. It recieves mail for two domains. cleevelink.co.uk and
cleevehillnursing.co.uk. There are two distribution groups setup both called
info one for each domain. The problem occurs when mail is sent to
email@example.com it is routed to the correct members, however
mail sent to firstname.lastname@example.org is routed to the members of
cleevehillnursing.co.uk not the cleevlink.co.uk
Any thoughts greatly recieved.
On Sat, 26 Nov 2005 08:05:02 -0800, "Kevin Cook"
<KevinCook@discussio...publisher preparing to install and configure problem
Every time I open Publisher 2002 it goes throught
the 'first time' preparing to install and configuring
setups, this gets very waring!! I have tried uninstalling
and re-installing to no avail. I am operating in an
windows XP Professional environment.
Have you got any virus programs installed?
If you have, end the program and then try and install Publisher 2002.
Do you get any error messages? If you do, what are they?
Hi kevin (email@example.com),
in the Microsoft� newsgroups
|| Every time I open Publisher 2002 it goes throught
|| the '...Weird attachment problem
I have a weird problem with an attachment.
I have a SQL Server 2000 with Reporting Services. Every morning it
generates a report and e-mail it to 6 people as an Excel attachment.
5 of those people also us Blackberry. I do not.
They can open the report on the BB, or through Outlook. If they use Outlook
Web Access, the message shows the paper clip, but when you open it, there
is no attachment. If I forward from OWA back to myself, I can open the
attachment in Outlook, but not OWA. If I forward my copy of that e-mail to
one of those users, they have the same problem. They can open attachm...Large PST file on network share <-- problems.
In my organisation a lot of users use a pst file to archive their mail.
Currently we have a lot of problem with pst files. I think te real problem
is the file server on which the pst files are stored.
Does any of you people know that there are known problems with large (500 Mb
+) pst files on a network share?
hope you can help.
omko h <firstname.lastname@example.org> wrote:
> Does any of you people know that there are known problems with large
> (500 Mb +) pst files on a network share?
There are known problems with any size PST on a network share. It's simply
not supported and disco...Problem with startup
I hate to ask a question so silly.
I have done something to my startup and can't display anything other than a
I can't see my tgable, queries, etc.
Can't figure out what I've done to get myself messed up.
Hold your shift key down when opening and then go to TOOLS > STARTUP and make
sure the DISPLAY DATABASE WINDOW checkbox is checked, if you want the db
window to be there when you open the database.
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, plea...Problem whit Default Storage Group and Default Public Folder
I have one problem, i hope that somebody can help me. Well here we go.
Result that my Default First Storage Group and my default Public Folder
sotorages, cannot mount any more.
This happen when an antivirus damage my databases 2 databases and when i try
to restore simply the stores not mount, i have an Exchange 2003 whit windows
2003 enterprise versions boot.
When this happen, i cannot mount the default First Storage Group and the
default Public folders, so i proceed to create a new Mailbox Store, and
recreate the mailboxes of my users to can continue working, but canno...Downloaded transaction screen
I just made the jump to Money 2005 and everything went just fine. I have a
minor problem if someone can help. In 2004, when I downloaded my
transactions from the bank the results would show up in an accounts list
page with the number of transactions for each account in parentheses next
to the account name. I was able to see which accounts had new
transactions. Now however, in 2005 the transactions are downloaded from a
particular account and just go to the other accounts and I must step
through each account to see if there is a new transaction to accept. I(s
there a way to get it t...Windows XP...computer shuts down and blue screen comes up with wri
I will be on my computer then all of a sudden it shuts down then blue screen
comes up with white writing on it...then disappears really fast...keeps
happening quite often. The computer restarts it's self back up. I don't
understand what is going on...I hope someone could please help me...Help
> I will be on my computer then all of a sudden it shuts down then blue screen
> comes up with white writing on it...then disappears really fast...keeps
> happening quite often. The computer restarts it's self back up. I do...Problem with Active X Control
I am integrating flash with VC++.
I am using Dialog Based App.
I inserted this Active X Control.
I wanted to show both this Control and Dialog Window in a maximized
I called ShowWindow(SW_MAXIMIZED) in OnInitDialog.
When I execute the App I get the main window in maximized but the
control in that is not at all maximized.
> I am integrating flash with VC++.
> I am using Dialog Based App.
> I inserted this Active X Control.
> I wanted to show both this Control and Dialog Window in a maximized
...Problems downloading from Max's website
Max, can you tell me how to download files from your web site? If I
rightclick, it downloads a file, but then when I go to open it, I get
an error message.
Clicking on your download button, opens another web page, with nothing
Believe my archives free filehost: savefile.com was down just now.
But it looks ok now (just tested here). Try again, just click "Download" ..
> Max, can you tell me how to download files from your web site? If I
> rightclick, it downloads a fil...SMTP problem: can receive but can't send
Exchange 2003 sp1
In my recipient policy i have few DOMAINs to receive and send mail for
opend my account in AD and changed default e-mail address to that new one
tested to send mail from externam mail server - got it
wanted to test a reply.. no reply im my external inbox
opened Exchange QUEUE and i can see my mail with: An SMTP protocol error
What can i do?
Enable the SMTP logging to get more information. This is done at the server
object > diagnostic logging >MSExchangeTransport >SMTP
Are you using a SMTP connector?
Is the DNS set up properly?
Can you send to othe...Vlookup Problem #14
I have a spread sheet, in which Col A has names of the users and Col B
has the supplier names, with whom the user work.
User Vendor Name
Kueyson Yee LIEBHERR AEROSPACE TOULOUSE SA
Kueyson Yee PULSE MIL AEROSPACE DIV
Kueyson Yee PULSE MIL AEROSPACE DIV
Lisa Thompson LIEBHERR AEROSPACE TOULOUSE SA
Lisa Thompson PULSE MIL AEROSPACE DIV
Lisa Thompson PULSE MIL AEROSPACE DIV
>From the above example, User Lisa can work with vendor Pulse, but
Kueyson cannot, in the same way Kueyson can work with vendor LIEBHERR
but Lisa cannot. Now to identify...Problems using GetFileVersionInfo
I'm trying to get the file's information from the VS_VERSIONINFO block.
I added the header file "winver.h" and included the "version.lib" in the
settings. I use the following to start with...
// ---- code -----
void GetInfoDlg::GetFileInfo( LPCTSTR lpszFile )
DWORD dwZero, dwInfoSize;
dwInfoSize = GetFileVersionInfoSize( (LPTSTR)lpszFile, &dwZero );
if( dwInfoSize > 0 )
LPBYTE lpBuf = new BYTE[dwInfoSize];
GetFileVersionInfo( (LPTSTR)lpszFile, 0, dwInfoSize,
&lpBuffer ); // get info
// TODO: Query the i...XmlNamespaceManager.LookupPrefix problem.
I have the following code:
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(@"<?xml version=""1.0"" encoding=""UTF-8""?>
XmlNamespaceManager namespaceManager = new
string prefix = namespaceManager.LookupPr...Auto-archive problem
In Outlook 2003, I have set all folders to be archived with the same
settings except for one that is never to be archived. The problem is that
some of the folders that should be archived, aren't. I've checked the
setting on these folders and they are set to the same archive settings as
Check the Modified date on the items that aren't being archived as you think
they should. That's the date Outlook uses to determine whether or not an
item is ready to be AutoArchived, and a simple action such as moving the item
to another folder can change th...Problem with redployment tool
I have been having difficulties with the redployment tool, and am at a stage
where I cannot continue and require some assistance.
Essentially, I get to the stage in the installation where I am to select the
existing databases. I enter the SQL server name, and the install dialog
shows me the correct database names, but when I click next, I get the
"Microsoft CRM Setup could not find a valid organization on the specified
database. You need to have at least one organization before installing
Our previous installa...Problems opening VNC links in IE
I've created a virtual map of my call centre with hyperlinks to each PC
terminal (selecting local address and adding in the appropriate VNC link for
each PC). This works fine in Visio, but when I try to export this as a web
page to add to the local intranet it prevents the VNC links from opening. I
have very limited Visio knowledge and can't figure out where I'm going wrong,
so any help would be greatly appreciated...
Well, since "This works fine in Visio", I'd start by verifying that the vnc
software is installed on the web server you are attempting to execu...