how to find URL in Excel 2007

[Ed White]

I recently upgraded from Excell 2003 to 2007. When I go to a website that has
a link to download data into Excel, and click on the link, and click to open,
Excel opens up with the data. In the 2003 version, the upper part of the
Excel screen would tell me which URL I just downloaded. I could then copy
the URL and navigate to it directly from Excel using the
workbook.open(filepath) command (with the URL as the filepath). In Excel
2007, I cannot find how to display which URL I just downloaded. How do I do
this?

 

[Jialiang Ge [MSFT]]

Hello Ed,

If I understand it correctly, you meant that in a computer with Excel 2003,
the workbooks in the webpages are opened in IE, with its URL displayed in
the IE address bar (or tab name), whereas, in a computer with Excel 2007,
the workbooks are opened in a new instance of Excel, instead of IE, and
from Excel, we are not able to directly see its URL. Am I right?

The change of behavior of Excel 2007 is documented at the KB article:
http://support.microsoft.com/kb/927009/
<quote>
When you try to open a Microsoft Office Word 2007 document, a Microsoft
Office Excel 2007 document, or a Microsoft Office PowerPoint 2007 document
in Windows Internet Explorer 7, the document may not open in the same
window as Internet Explorer. Instead, a new Word 2007, Excel 2007, or
PowerPoint 2007 window opens to display the document.
</quote>
By applying the workaround in this article to your computer, the workbooks
will be opened in IE like the default setting of Excel 2003, and you will
be able to see the workbook URL in this way.

For more readings about how to configure Internet Explorer to open Office
documents in the appropriate Office program (for Office 2003) instead of in
Internet Explorer, please refer to the KB:
http://support.microsoft.com/kb/162059

Please let me know if you have any other concerns, or need anything else.

Regards,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Ed White]

Actually, that is not what I meant.

When in IE, I click on a link to open a spreadsheet. The spreadsheet
correctly opens in a new window in Excel (not Excel within IE, but within an
Excel instance). So far, so good. When looking at the Excel 2003 screen, I
don't know the name of the area of the screen, but typically below the input
area where you type in formulas, etc., is another line that tells you the URL
of the page you just downloaded. It always appeared automatically when I had
Excel 2003 installed and I had clicked on a link to get to that spreadsheet.
Now with Excel 2007 installed, I never see the URL information, and I've
looked all over the ribbon to look for some option to display it, and I can't
find it. All I want to know is, when I click on an IE link to open up an
Excel spreadsheet, shat is the URL that I can navigate to directly from
within Excel to get to that same spreadsheet?
--
Ed

Hello Ed,

If I understand it correctly, you meant that in a computer with Excel 2003,
the workbooks in the webpages are opened in IE, with its URL displayed in
the IE address bar (or tab name), whereas, in a computer with Excel 2007,
the workbooks are opened in a new instance of Excel, instead of IE, and
from Excel, we are not able to directly see its URL. Am I right?

The change of behavior of Excel 2007 is documented at the KB article:
http://support.microsoft.com/kb/927009/
<quote>
When you try to open a Microsoft Office Word 2007 document, a Microsoft
Office Excel 2007 document, or a Microsoft Office PowerPoint 2007 document
in Windows Internet Explorer 7, the document may not open in the same
window as Internet Explorer. Instead, a new Word 2007, Excel 2007, or
PowerPoint 2007 window opens to display the document.
</quote>
By applying the workaround in this article to your computer, the workbooks
will be opened in IE like the default setting of Excel 2003, and you will
be able to see the workbook URL in this way.

For more readings about how to configure Internet Explorer to open Office
documents in the appropriate Office program (for Office 2003) instead of in
Internet Explorer, please refer to the KB:
http://support.microsoft.com/kb/162059

Please let me know if you have any other concerns, or need anything else.

Regards,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Jialiang Ge [MSFT]]

Hello Ed,

As far as I know, there is a function in Excel 2007 that can show the URL
information of the workbook:

1. Click on the Office icon on the upper-left side of Excel after the
workbook is opened.
2. Go to Prepare menu and choose Properties.
3. A Document Properties form shows above the formula bar, with the
Location information, i.e. the URL of the workbook in the first line.

Is this what you are looking for?

Regarding Excel 2003, I do not see the corresponding "area" below the
formula bar as you said. When a workbook in a webpage is opened with Excel
2003, I only see the worksheet tables below the formula bar on my side. Ed,
would you mind sending a screen-print of that area to my mailbox:
(e-mail address removed)?

Thanks,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

=================================================
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================