Free Microsoft Excel 2013 Quick Reference

Excel links break on network

I have number of excel files with 3 to 4 links in most of the file, shared on
intranet, now i am having the problem that when any user other than me access
to these files through intranet the links break everytime and the information
from the linked source not updated until links are updated everytime when
file is open through intranet ad when any user access any excel file and save
it with any changes he made i got the same problem when i open from my
location, infact i have control of these files and files are stored on my pc
Is there any remedy or solution that can help and prevent the links to break
everytime when access from any location.
Regards


Post your answer or comment

comments powered by Disqus
Hi,
We have a financial report that multiple people use that pulls data from other workbooks (these are all located on our network) and excel has decided that for the file links it will sometimes add the local users path to their XLSTART folder at the start of the link, breaking it for everyone else.
i.e
T:Reporting[M1R2.xls] will turn into
2008sbsusers%NAME%Application DataMicrosoftExcelXLSTARTT:Reporting[M1R2.xls]

This is happening on excel 2010 and 2003.

Any way to turn this off?

I have 2 worksheets with linked fields such that worksheet A is used for data input, and worksheet B has formulas that process that input. They are in separate files as well. With both files open on a single PC, when I update worksheet A data (without saving) I instantly see the changes in worksheet B's dependent data.

However when I open worksheet B from a different PC on the network, mods to worksheet A are not seen at all. The links in worksheet B look good and reference the UNC path to the correct file A and specific fields within the formulas look good but no joy on instant updates being seen in worksheet B.

I am running Excel 3003 on both systems with XP -- should this work across the LAN seamlessly or am I missing something? I have tried making worksheetA shared but makes no diff.

Thanks in advance -- I have searched and don't see this on the board.

I have a user that created a spreadsheet. For each row entry there's a
hyperlink that he created. The hyperlink pulls up a jpg and it's pointing to
a shared drive via UNC path and everyone has adequate permissions to access
this drive. If you access his Excel file on the network (stored in same UNC
location as jpgs) the links work. However, if you copy his Excel file to
your desktop or anywhere else the links break. We get a message that says
'Cannot open the specified file.' I'm confused. Everyone has access to the
network location that the links point to and the links use a UNC path. Even
the user that created this file has the links break if he copies it locally.
Is there something he's doing wrong? I can't figure it out. If you hold the
mouse over the broken link here's what you will see verbatim on my computer:

file:///C:Documents and
SettingsmcgowensDesktop512.002CG512.002CG_Fron t.jpg

Now, if you access the file from its network share and hold your mouse over
the same link, here's what you will see verbatim on my computer:

file:///nasden01commonleases512.002CG512.000CG_Front .jpg

What's happening? Why do the links work if accessing the Excel file over
the network but if you copy the Excel file locally the links break? I don't
get it. The links are UNC and everyone has permission to access the specfied
directories.

Thank you for all of your help!

I have a user that created a spreadsheet. For each row entry there's a
hyperlink that he created. The hyperlink pulls up a jpg and it's pointing to
a shared drive via UNC path and everyone has adequate permissions to access
this drive. If you access his Excel file on the network (stored in same UNC
location as jpgs) the links work. However, if you copy his Excel file to
your desktop or anywhere else the links break. We get a message that says
'Cannot open the specified file.' I'm confused. Everyone has access to the
network location that the links point to and the links use a UNC path. Even
the user that created this file has the links break if he copies it locally.
Is there something he's doing wrong? I can't figure it out. If you hold the
mouse over the broken link here's what you will see verbatim on my computer:

file:///C:Documents and
SettingsmcgowensDesktop512.002CG512.002CG_Front.jpg

Now, if you access the file from its network share and hold your mouse over
the same link, here's what you will see verbatim on my computer:

file:///nasden01commonleases512.002CG512.000CG_Front.jpg

What's happening? Why do the links work if accessing the Excel file over
the network but if you copy the Excel file locally the links break? I don't
get it. The links are UNC and everyone has permission to access the specfied
directories.

Thank you for all of your help!

Hi All

I am having intermittent episodes of an excel spreadsheet not responding. doesn't seem to be reason for it, and after a few minutes it comes back up. The sheet had a number of DDE links which are constantly updating. These links are a price feed. There are no problems with the shared drive. Theres not any vba code running in the background or major calculations going on. My main problem is how to investigate a problem like this there seems no obvious avenue.

I'd appreciate views on this issue.

Cheers

John B

I have built a PowerPoint presenation that utilizes numerous Excel-linked slides, all of which will need to be updated by the presenter. The Excel and PowerPoint files have been saved in a single folder, the contents of which will be e mailed to the users.

The problem I am having is that when the folder is moved or copied from one directory to another (either on a network or on the hard drive), some of the links seem to properly "travel" and adjust themselves automatically to the new path of the linked Excel file. Others, for no reason that I can identify, still refer to the previous path of the Excel file.

I've even tried changing the link path manually and re-saving the file, but when I close and re-open it, the linked path has returned to its previous state before I changed the links.

Can anyone suggest how to correct this problem? I created all of the links in an identical fashion, and can think of no other reason for this inconsistent behavior.

Thanks in advance.

Lets say there is a network folder named for each month, inside there is
a bundle of heavily linked reports that cannot be integrated into just
one workbook. Each new month the folder is copied and renamed to the
current month to update the data. Links keeps pointing to previous
folder structure and changing them it's time wasting and confusing
because of the little room on the excel links dialog...

I have not yet found a way to make the process practical as it is in
webpages. Why can't links just point to the files regardless of folder
or even use ../folder_x/ to force them navigate into the folder
structure as it is in webpages relative links?

Well, obviously excel is one program and webpages are other thing, but
perhaps someone else having the same inconvenience has found a better
way to do it or can give some advice...

Thanks. Paul.

--
Paul134
------------------------------------------------------------------------
Paul134's Profile: http://www.excelforum.com/member.php...o&userid=31735
View this thread: http://www.excelforum.com/showthread...hreadid=518220

User open excel file on network drive and then she save and close. She open
this file again but it alert "read-only and this file open by she". I see
session open file on server and found that this file opening, actually this
file closed. I go to user desktop and open task manager and see execl task
still running. How to fix this problem?

I tried to open an excel file on network drive, it says "XXX.xls is locked
for editing by abcd", then with options to open "read only", "notify" or
cancel.
obviously, even that person said to lock also can't open.
I can open readonly and save as new file, however, I can't move or delete
old file.
Any idea what went wrong.
I googled it, it seems to be problem with file server.

thank you.

I tried to open an excel file on network drive, it says "XXX.xls is locked
for editing by abcd", then with options to open "read only", "notify" or
cancel.
obviously, even that person said to lock also can't open.
I can open readonly and save as new file, however, I can't move or delete
old file.
Any idea what went wrong.
I googled it, it seems to be problem with file server.

thank you.

User open excel file on network drive and then she save and close. She open
this file again but it alert "read-only and this file open by she". I see
session open file on server and found that this file opening, actually this
file closed. I go to user desktop and open task manager and see execl task
still running. How to fix this problem?

Lets say there is a network folder named for each month, inside there is a bundle of heavily linked reports that cannot be integrated into just one workbook. Each new month the folder is copied and renamed to the current month to update the data. Links keeps pointing to previous folder structure and changing them it's time wasting and confusing because of the little room on the excel links dialog...

I have not yet found a way to make the process practical as it is in webpages. Why can't links just point to the files regardless of folder or even use ../folder_x/ to force them navigate into the folder structure as it is in webpages relative links?

Well, obviously excel is one program and webpages are other thing, but perhaps someone else having the same inconvenience has found a better way to do it or can give some advice...

Thanks. Paul.

why do changes only save locally on networked excel file?

hello,
I want to create an excel link over a network.
computer 1 has a1.value 1 for example
and when i change that it must auto change on computer 2 in the same cell.

is that possible?
cheers
frank

Hello,

I would appreciate any tips as to how I can set a break on the Y-axis of
an excel graph? Im using a vertical bar graph.

Thank you very much!

Hala DC

Hi all,
I have a very simple macro to open a form linked to a command button:


	VB:
	
 
Private Sub Button2_Click() 
    EnterTrain.Show 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Whenever I run the macro it breaks on the line EnterTrain.Show even though there is no break point set. There is no error message, it just breaks and highlights yellow.

It is very strange because when I open the form from the intermediate window or by pressing F5 there is no break or error.

I thought it might be linked to some code in the form itself so I removed all the code in the form as a test and it still breaks! I have compiled, created a new module, exported and imported the form all to no avail.

I have searched forums and it seems others have experienced this but there seems to be no solution.
Does anyone know how to fix this?

Thanks,
janie

Hi all,

I have 2 spreadsheets, one gathers information from another.
From A1:F801 data is stored in Cancellation_Report.xls.

When I open my 'master.xls' and it asks me to update, it updates no problem.
However, when I save a new version of Cancellation_Report.xls into the directory and open up the master, all the links break because the Cancellation_Report.xls file has not been opened and saved with the new data.

I use the following code in the A1 cell for master and so on for the cells up to F801.

='Y:[Cancellation_Report.xls]Cancellation Report'!A1

Any ideas how I can just save over the Cancellation_Report.xls file and have the links update without having to open and save the Cancellation_Report.xls file?

Thanks

Tayler

If the source file [Test.xls] is open by some one else on network then the below code opens the file locally while reading it (opening the recordset), which I don't want. This is not happening when the source file is closed.

I am using the below code:

	VB:
	
 importData() 
     
    Dim cnt As ADODB.Connection 
    Dim rst As ADODB.Recordset 
    Dim fld As ADODB.Field 
    Dim stSQL As String 
     
     'Network path
    DataSource = "K:MyPathTest.xls" 
     
    stCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & DataSource & _ 
    "; Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'" 
    Set cnt = New ADODB.Connection 
    Set rst = New ADODB.Recordset 
     
    cnt.Open stCon 
     
    stSQL = "SELECT * FROM [Sheet1$]" 
    With rst 
        .CursorLocation = adUseClient 
        .Open stSQL, cnt, adOpenStatic, adLockReadOnly 
        .ActiveConnection = Nothing 'Here we disconnect the recordset.
        MsgBox .Fields.Count 
    End With 
End Function 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
CAN ANYONE SORT OUT THIS PROBLEM

Thanks
Dev

Hi, I googled for my problem, searched in forums, but till now I haven't found a solution.

Basicly I have a workbook (let's say named Test.xls) with MatLAB Excel Link addin enabled (basically Excel Link allows Excel to use MatLAb for various computations while using Excel as the front-end).

I have a macro like this (Predict is a function written in Matlab, all I do is call the function via a command button):

	VB:
	
 CommandButton_Izvedi_Click() 
    ActiveWorkbook.Save 
    MLEvalString "Predict" 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
In the "Predict" function I use several xlsread and/or xlswrite commands (reading from Test.xls, writing into some other workbook). For every such command I get the error mentioned in the title. Actually everything works as it should, but you need to click "End" at every error popup, which is annoying.

This might be more of a Excel link related question (I'll post a question on their forums, too), but just checking if you guys have any ideas.
Thanks

Not really sure if it's excel or access question

An application is trying to open Excel from Access. Has been working fine for over a year, still works on all PCs except 1.
On that particular PC code breaks on


	VB:
	
 X = CreateObject("Excel.Application") 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
if I put

	VB:
	
 X = CreateObject("ADODB.Connection") 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
It goes fine past that line, so it means that 'CreateObject' works fine, it's just cannot create Excel

I checked References, nothing is MISSING
Are there any dlls that are required or anything like that ?

I have a document that moves from person to person. Within this file, I have multiple links to other documents on the network.

Since, for some reason, dfferent departments have different letters for the same mapped drive, something to do with security, I am having a hard time keeping all the links straight.

Instead of creating links for each department, I was wondering if there was a way to set a base herf as in HTML that will solve this issue.

I am sure this can be done by evaluating the user and then changing all the links based on their department, but this would have to be ran everytime someone different opened the file.

Ok I'm a complete noob, I've cannibalized my fair share of other people's code in my time though to make my life easier. I have to say I love playing with excel and vba. I'm a controls engineer for the automotive industry so really I deal with a different kind of code completely. A couple years ago I found out you can link through the dde to Rslogix and I've been playing with it ever since.

I made a cycle timer a long time ago that I found just wasn't versatile enough for what I wanted so I tried to mess around with it to make it auto update and change dde links based on configurable cell values. That I found really hard to do just using the & because it just doesn't like it.

Basiclly what I'm trying to do is put together a link that looks like this

=(RSLINX|MF11!'_020S01_Cycle_History[1],L1,C1')

That will get me to the data I want to display. That works fine but I want to be able to assign "MF11" to be whatever I have in another cell. I also want to be able to assign the 20 out of _020S01 from a drop down menu. It all works fine and good when I use the & but I have to do a =("=(RSLINX|&a1&!'_0&a2 etc etc kind of thing and it doesn't want to link that way for some reason. It displays exactly how I want it to but it doesn't link and display the value like it would if I just type the raw string.

Ok so I get to playing around because I'm a presistant little bugger and I find that I can write that same code in VBA and populate a textbox with it using

Private Sub TextBox2_Change()

TextBox2.Text = "=(RSLINX|" _
& Range("CycleTime!H24") _
& "!'" _
& "_0" _
& Range("CycleTime!H26") _
& "_OC01.oCurrentCycleAcc" _
& ",L1,C1')"

Me.Range("CycleTime!C5").Value = TextBox2.Value

End Sub

Then I used the last line to populate a cell based on the value in the text box and it links the cell fine but the textbox shows the raw text lol.

Ok it's kind of confusing but I'm a self pronounced noob, all I really want to do is make a large cycletime spread sheet that I can take to a machine and type in the topic (MF11) and the station number (20) into cells on the worksheet and have it update alot of other cells right away. I don't really want to use textboxes but I will if I have to. I'd like to just write vba code that populates it dynamiclly.

Please help a noob

Does anyone know any VBA code that can be used to set a page break on the fly? I am designing a report with multiple worksheets, containing paired bar charts and a corresponding data row. If 'sheet1' has 2 paired bar charts with each set having it's own data row, there is no problem with the page breaking 'normally.' The problem arises if there are too many charts/data rows for 1 page, and excel breaks the page automatically. I would like it to break so that an entire pair and it's corresponding data is on one page, vs half of the data on one page and the other half on the next page.

Background:
-----------

I was tinkering with a larger Excel file on a network drive (~7 MB) and
tried to run a macro that wasn't there (using keyboard shortcut of Ctrl-D).
Obviously, nothing happened. In response, I tried to create a new tab (Excel
seemed to be doing this, but it failed three times; no new tab appeared). I
then figured it was time for a computer reboot.

After rebooting, I tried to open the aforementioned file, only to be met
with the 'Error -> Send Error Report' dialog. Repeated attempts to open this
file yield the same results. I tried rebooting again, but the results
remained the same.

TWIST #1:

Another computer in our office was able to successfully open this file. I
had them create a copy of it, figuring I could get into that one & trash the
original. However, I get the same crash/error dialog when trying to open
that file.

TWIST #2:

I am able to open other Excel files, both on my local HD as well as some in
the same folder where the problem Excel file resides.

So, is anyone familiar with a problem such as this? Obviously, there appears
to be something about this file now & my work computer that refuses to let
me open it on my work machine.

Any assistance would be appreciated.

--
---
k


No luck finding an answer? You could always try Google.