Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=HYPERLINK function and Excel 2003 problem.
Hello,
I have a worksheet with addresses of the clients, so each row represent one client (Name, Title;Street+no, ZIP, city ...) I would need to put on the first column a special hyperlink, which will be composed from the values of next columns. Like : =HYPERLINK("http://www.abc.abc?Parameters=Excel"&";"&C12&";"&IF(D12=$ C$5;0;IF(D12=$C$6;1;IF(D12=$C$7;2;3)))&";"&E12&";" &F12&";"&G12;"Open in browser") So the hyperlink would look like http://www.abc.abc?Parameters=Excel;John Dick;0;Lombard street 1204;10304;Zurich ... But the hyperlink does not work, when in one or more of the cells is a value containing space - in this example the name and street. I've tried to replace the spaces with %20, but still the same. Simply Excel will not open the browser, nor display an error message in those cases... However, if I remove the space, it works. This problem occurs only in Excel 2003, in XP it works.. Ajo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
@ and "function not valid" error (Excel 2003) | New Users to Excel | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Excel 2003 Slowness problem in Windows XP | Excel Discussion (Misc queries) | |||
CHR() function not working in Excel 2003 | Excel Discussion (Misc queries) |