Free Microsoft Excel 2013 Quick Reference

Excel cannot access files on a network.

Hello Excel Experts,

I am the network admin of a small school that is very reliant on excel. The strangest thing has just happened today. Whenever we try to open an excel file that is located on the central server you get an error that reads:
Cannot access 'filename.xls'.
I initially thought the file was damaged, but this happens for every .xls file I try and under every user name and user group as well. However, I did find a loophole. If i make a copy of the file on my local machines c: drive, I can then open the file and e-mail it as an attachment. The only problem is that regular users can't save onto their c: drives, and if they save the attachment onto their desktop or My Documents, they won't be able to open it because of this same issue. Sometimes if I try to copy a file, I will get:

"Cannot copy 'filename.xls' It is being used by another person or program'
If you have any experience with this issue or have any suggestions your help will be greatly appreciated!
Thanks!!!

-dan


I am presently using Windows 2000 and Excel 2003. Whenever I try to save a
file on a networked drive I get an error message indicating the folder is
write protected. I have checked the folder attributes and it is not write
protected.

Hi

This is my first post - so please be gentle

I am using Excel 2007 - wondows 7 and windows XP - all with latest service packs.

I have 2 linked files - a master file on a network drive which is linked to a data file on the same network drive - in a sub folder.

I created a link from the master file to a cell in the data file and it works fine. The link looks like this:

='NR2K0206GENERALPLANT MANAGEMENT SYSTEMProject reveiew[Reduce Levels.xlsx]PROJECT TEMPLATE'!$A$1

- where NR2K0206 is the network drive address.

However after saving both the master file and the data file and then making some changes to the data file - the master did not update. I clicked on the link and it had changed to the following:

='C:Documents and Settingsnln8720Local SettingsTemporary Internet FilesContent.OutlookNR2K0206GENERALPLANT MANAGEMENT SYSTEMProject reveiew[Reduce Levels.xlsx]PROJECT TEMPLATE'!$A$1

- where nln8720 is the local logon username.

It appears to have replaced the network location with the local hard-drive location.

Any suggestions? Thanks!

First dialog box show that : Excel cannot access "file name". The document
may be read-only or encrypted.
Then second dialog box show up : Cannot access "file name".

Any idea to solve this problem?

Thank you.

I have a workbook that I use on a daily basis that I cannot seem to get
to open now.

I was in it, then closed it down and when i went to reopen it later on
it gave me the error: Excel cannot access the file ***.

Is there a way around this?

--
bpalluck
Posted from - http://www.officehelp.in

Hi Forumites,

Im new to this forum, dont ya just love google!.
--->>

This should be an easy one for you.

I have a test XLA file, that i want to add more useful functions to, so

i can use this site wide.

For example:
-----
Public Function Get_Time() As Date
Get_Time = Time
End Function
Public Function Get_Date() As Date
Get_Date = Date
End Function
Function Trunc_String(InString As String, Chars As Long) As String
Trunc_String = Left(InString, Chars)
End Function

Public Function test_fun()
MsgBox ("fff")

End Function
-----

I want to be able to create Excel files that use these functions. then
give the Excel XLS file to the users. These are usually tools for
formatting/extracting data etc.

How can i ensure that when i give the file to a user, it will pick up
the latest XLA file. Id also like to put the XLA file on a network
drive, so we can all use the one library file.

Usually you need to add the XLA file to the references too, but i dont
(or cant rely) on the users to do this. i need the XLA file to be
called from the code in some way, so the user doesnt need to worry
about it.

Any suggestions please

Arty.

Lets say I want a department to all have access to the same macros. Is
there a way I can make a computer point to a specific personal.xls file
on a network drive so that I can just update that one file and all
users will benefit from the changes made? Also, I do not want users to
be able to modify this personal.xls. Do I just need to flag it as
read-only in the file system?

I have a number of files on a network drive that are used by several users on a daily basis.

Recently, users are telling me that they get an error message, when they try to update existing files on the drive with new data. Basically what happens is that Excel freezes, and an error message states that data was partially lost in the attempt to save the file.

It appears to be a problem only with files of a certain size. The last report I had was on a file of about 2 MB.

The Office version is 2002, the client OS is XP, and the file server is running Windows Server 2003.

Any ideas out there?

T.i.a.

Hello,

Just wondering if you guys had any suggestions on what could be a good solution in order to have an interactive map (such as Google earth) and to be able to click pins/icons on areas on that map to open a specific excel row referencing files (on a network drive) pertaining to that area. Would this be possible with google earth? Just looking for a recommendation before I jump into this head-first.

Thanks!

I'm opening files on a network share and the most recent changes made by me
on another computer are not showing up. They will show up if I navigate out
to the network share and right-click the .xls file and tell it to
synchronize, and then open it.

I don't want to have to manually synchronize every time I open the file.

Anyone have any ideas?

How to make Excel 2007 open XLS files on a singel instance

Hello to all!

I just want to ask, how would you make Excel 2007 open XLS files on a single instance. Or how could you make Excel 2007 to restore its original settings that opens XLS files, even those that were made using Excel 97-2003, on a single instance. One of our staff has made some changes and had altered these settings and we would want to revert back to the time when her Excel would open files on a single instance.

Thank you very much in advance.

Jerry

Hi
Very important accounting(which is 26 KB only) excel file is not allowing me to open the file. I may encrypted this worksheet and immediately turned into green colour, 6 months later i reinstalled windows XP pro but this time iwhen i try to open

First dialog box show that : Excel cannot access "file name". The document
may be read-only or encrypted.
Then second dialog box show up : Cannot access "file name".....
i tried openoffice.org but didnt solve the problem.I never used any password for this file.
I think this excel file ,when i choose the option to encrypt ,it got a certificate
from windows xp and when i reinstall it ,it can not reach the same certificate.
ANy idea how to open this important file ?
you can write to me at info@turklandproperty.com

Thanks in advance

Hi
Very important accounting(which is 26 KB only) excel file is not
allowing me to open the file. I may encrypted this worksheet and immediately
turned into green colour, 6 months later i reinstalled windows XP pro but
this time iwhen i try to open

First dialog box show that : Excel cannot access "file name". The document
may be read-only or encrypted.
Then second dialog box show up : Cannot access "file name".....
i tried openoffice.org but didnt solve the problem.I never used any
password for this file.
I think this excel file ,when i choose the option to encrypt ,it got a
certificate
from windows xp and when i reinstall it ,it can not reach the same
certificate.
ANy idea how to open this important file ?you can write to me
at info@turklandproperty.com

Thanks in advance

THe file runs great on a local directory but after I moved it to the networked location I ran into some issues.

I get and error that:

Microsoft Excel cannot access the file 'H:Supply OperationsApheresis Network ManagementAph Monitor ReportsMonitoring ReportsReports200_22552-01_10252010.xls'. There are several possible reasons:
The file name or path does not exist
The file is being used by another program. The issue is that the file in question is not even on that drive, the reports folder is empty! I even looked for hidden files etc.

Is it possible that Excel is cacheing the filename?


	VB:
	
 
Sub LoopDirLoopFiles3a() 
    Dim wbOpen As Workbook 
    Dim wbMaster As Workbook 
    Dim strDirSub As String 
    Dim strExtension As String 
    Dim oFS As New FileSystemObject 
    Dim oDir 
    Dim strDir 
    Dim oSub 
    Dim lngRowT As Long 
    Dim lngRowB As Long 
    Dim lngRowN As Long 
    Const lngColT As Long = 254 
    Dim wsTarget As Worksheet 
    Dim wsBatch As Worksheet 
    Dim wsNote As Worksheet 
    Dim strMasterName As String 
    Dim strTargetName As String 
    Dim intX1 As Integer 
    Dim intX2 As Integer 
    Dim intMatch As Integer 
    Dim CopiedSht As Collection 
    Dim Sht 
    Call ClearData 
     'Comment out the 4 lines below to debug
    Application.DisplayAlerts = False 
     'Application.ScreenUpdating = False
     'Application.Calculation = xlCalculationManual
     'On Error Resume Next
    Set wbMaster = ThisWorkbook 
    Set wsBatch = wbMaster.Worksheets("Batch") 
    Set wsNote = wbMaster.Worksheets("Note") 
    strMasterName = wbMaster.Name 
    strTargetName = wsNote.Range("A6").Value 
    lngRowB = wsBatch.Cells(Rows.Count, 1).End(xlUp).Row 
    strDir = wbMaster.Path 
    ChDir strDir 
    lngRowN = 10 
    Set CopiedSht = New Collection 
    Do While Len(wsNote.Cells(lngRowN, 1).Value) > 0 
        CopiedSht.Add Item:=Cells(lngRowN, 1).Value 
        lngRowN = lngRowN + 1 
    Loop 
     'MsgBox CopiedSht.Count
    Set oDir = oFS.GetFolder(strDir) 
    For Each oSub In oDir.SubFolders 
         'MsgBox oSub.Path
        ChDir oSub.Path 
        strExtension = Dir("*.xls*") 
        strDirSub = oSub.Path & "" 
        Do While strExtension  "" 
            intMatch = 0 
            For intX1 = 1 To CopiedSht.Count 
                If strExtension = CopiedSht.Item(intX1) Then 
                    intMatch = 1 
                End If 
            Next intX1 
             
            If intMatch = 0 Then 
                [B]      Set wbOpen = Workbooks.Open(strDirSub & strExtension) 'ERROR ON THIS LINE[/B]
                 
                For intX2 = 1 To wbOpen.Worksheets.Count 
                    wbOpen.Worksheets(intX2).Visible = True 
                Next intX2 
                 
                Set wsTarget = wbOpen.Worksheets(strTargetName) 
                lngRowT = wsTarget.Cells(Rows.Count, 1).End(xlUp).Row 
                 
                If lngRowB = 1 And lngRowT > 0 Then 
                    wbOpen.Activate 
                    wsTarget.Select 
                    Range(Cells(1, 1), Cells(lngRowT, lngColT)).Copy 
                    wbMaster.Activate 
                     'wsBatch.Select
                    wsBatch.Cells(lngRowB, 1).PasteSpecial Paste:=xlPasteValues 
                    Application.CutCopyMode = False 
                End If 
                 
                If lngRowB > 1 And lngRowT > 0 Then 
                    wbOpen.Activate 
                    wsTarget.Select 
                    Range(Cells(2, 1), Cells(lngRowT, lngColT)).Copy 
                    wbMaster.Activate 
                     'wsBatch.Select
                    wsBatch.Cells(lngRowB + 1, 1).PasteSpecial Paste:=xlPasteValues 
                    Application.CutCopyMode = False 
                End If 
                 
                lngRowB = wsBatch.Cells(Rows.Count, 1).End(xlUp).Row 
                 
                 'wbMaster.Activate
                lngRowN = 10 
                Do While Len(wsNote.Cells(lngRowN, 1).Value) > 0 
                    lngRowN = lngRowN + 1 
                Loop 
                wsNote.Cells(lngRowN, 1).Value = strExtension 
                 
                With wbOpen 
                     '.Sheets(2).Copy after:=wbMaster.Sheets(wbMaster.Sheets.Count)
                    .Close SaveChanges:=False 
                End With 
            End If 
            strExtension = Dir 
        Loop 
    Next oSub 
     'MsgBox wbMaster.Name
    wsBatch.Select 
    Cells(1, 1).Select 
    wbMaster.Save 
    wbMaster.SaveAs Filename:=strDir & "Master.txt", FileFormat:=xlText 
    Workbooks.Open (strDir & "" & strMasterName) 
    Windows(strMasterName).Activate 
    Worksheets(1).Select 
    Set wbMaster = Nothing 
    Set wbOpen = Nothing 
    Set wsBatch = Nothing 
    Set wsNote = Nothing 
    Set wsTarget = Nothing 
    Set CopiedSht = Nothing 
    Windows("Master.txt").Close 
    Application.DisplayAlerts = True 
    Application.ScreenUpdating = True 
    Application.Calculation = xlCalculationAutomatic 
    On Error Goto 0 
End Sub 

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


Hi:

Ten networked office computers need to access an Excel file (an editable chart which logs the dates that patient medical record requests are made and dates that medical records are received) which resides in one computer's Shared folder (the Host). Sharing access is enabled. When a first Client opens the Host file on their computer, they edit the file as needed. If a second Client opens the Host file, they don't yet see the edited changes because the first Client has not yet saved the file to overwrite the Host file. With multiple instances of the Host file open on the varied Client computers, in various stages of editing, each can't be saved to overwrite the Host file because they are locked for editing. Only a temp Client copy of the file can be saved to each Client's computer. This defeats the purpose of trying to have one master Host file which reflects all changes made to the file on each Client computer. Is there any efficient work-around for 10 people to be able to work on one Excel file, and for all to save their work to one master Host file?

Thanks.

Adam

I have this problem at work (using Excel 2000 Windows 2000) and at home
(Excel 2003, Windows XP Pro). SOMETIMES...not always, I try to access a file
on a network drive I get the message: "path..filename could not be found.
Check the spelling of the file name and verify that the file location is
correct". Once I get the message on that file, I always get it on the
file....but there might be 27 others in the same folder that I can open. And
I get the message if I try to open the file via explorer or via Excel. If I
copy the file to my C: drive it opens fine. I even tried to copy to the c:
drive, delete it off of the network drive and then copy back to the network
drive and I get the same message. I'm stumped.

Hello,
I have a excel file on the network. Multiple users access this file. I’ve configured all the Excel with the data to users who use it. My problem is that I don’t know who is using the Excel file.
When I open the “Excel File” and other person is using the file, you can see:

File In Use
The file is locked for editing
“another user”

Not display the name of the user who is using the file.

You know I can do to show the “user name” or “computer name”?

Thanks!

Does anyone know why acess of Excel 2002 from a Network Attached Storage (D-Link DNS-323) is blocked when I set up a password group on the NAS. I can access and open all sorts of other files - .eml, .pdf, .mp3, .mpg, but cannot get Word or Excel to open. Excel gives me these messages

On my two XP machines I get
(1) "Excel cannot access '(filename.xls)' The document may be read-only or encrypted". One machine is using Excel 2003 (11.8237.8221) SP3 and the other XP machine has Excel 2002 (10.6852.6845) SP3

On my vista machine it says
(2) "Access denied. Contact your admistrator". This machine is using Excel 2007 (12.0.6331.5000) SP1

I have posted and received many replys over at the D-link DNS-323 forum and users say they have no problem opening Excel files when passwording their NAS. I updated the NAS to latest firware yesterday but that didn't fix this problem.

Only problem files seem to be Excel and Word. Excel is the most important to me and I really don't like to have open access to the NAS. It is only a home environment so not a problem of who the user is inside the building, but am using always on cable modem, and would like to restrict access to the NAS on network. ANY IDEAS?

Several Users are sharing a workbook over a Network. While Saving, users
receive the message that they can no longer access the workbook as it is
unavailable. The original file "schedule.xls" changes to an 8 charactor
filename 2729CE00. Are there too many users? Could it be network
interference?

--
cell
------------------------------------------------------------------------
cell's Profile: http://www.excelforum.com/member.php...o&userid=32636
View this thread: http://www.excelforum.com/showthread...hreadid=524443

Hi,

I have a problem in my company with linked spreadsheets and everything I have tried has failed, I am hopinh someone can help.

We recently upgraded all workstations to Office XP, everyone is ok apart from the Accounts department.

4 people who all share linked spreadsheets on a network drive. The problem is that not all of the links are working on all of the PCs. E.G.

Person 1 will open 2 sheets that are linked with no problems. Person 2 will open same sheets on a different PC and the links do not work. On Person 2's PC the links are referring to UNC path but not on Person 1's PC. If I update the links (Edit, Links, Edit Source) on Person 2 they work fine, however when Person 3 opens up the same files they cannot access (UNC paths again).

We have upwards of 600 links within all the files and there appears to be no pattern to this behaviour.

Has anyone came across this before or are there any tools out there to fix the UNC path problems.

Yours in hope
Col

Several Users are sharing a workbook over a Network. While Saving, users receive the message that they can no longer access the workbook as it is unavailable. The original file "schedule.xls" changes to an 8 charactor filename 2729CE00. Are there too many users? Could it be network interference?

Hi All,

As above i have a macro which opens a workbook which is on a network drive. This works fine for my multiple users...however i have discovered that if they do not have the drived mapped with the same drive letter at the start...it will throw up an error advsing that the file does not exist.

Is there any way to by pass this.

Ex - "TestFile.xls"

File is stored in "E:NetworkTeam1Testfile.xls"

However, some users have access to this file and it is mapped as E:, but some users have been mapped as F: The advisors who have been mapped as F: cannot access the file.

Is the VBA/Macro smart enough to bypass the drive letter and just search the rest of the past...NetworkTeam1Testfile.xls".

Many Thanks

I have just installed Excel 2010 in an office environment and when I click to save a file on a network drive I get an error message telling me that the file name cannot be found, check my spelling, or try a different path. When I say OK it tells me to click the file tab, point to save as and Excel workbook and specify a location on my computer.

This is not about permissions I have permissions in place and I didn't have any issues with previous version of excel nor do I have problems with any other file (other than saving emails from outlook where the same thing happens). If I do save the file locally to my PC I am then able to drag and drop it where I want using file explorer.

I have seen the same issue from other users on other forums but wondered if anyone on here knows the answer.

Hello all

I am having problem trying to use VBA to check-out, open and modify an Excel file on a Sharepoint site.

I have fallen at the first hurdle - in trying to check the file out. I have used the following code to attempt this:


	VB:
	
 
    Workbooks.CheckOut strFile 
    ... 
End If 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
where strFile is the path and file name of the Excel workbook.

It gives the error message "Cannot perform this operation. The file has been deleted or someone else has it checked out.", when the file is clearly not checked out.

Any ideas what could be going wrong? I have the necessary permission to open and edit the file... perhaps could be something to do with the site settings??

Thanks in advance.

When I try to open a spreadsheet on a network drive, it acts like it will open but then the excel screen just greys out.

Others in my department are able to access it but me and nobody seems to know why. I have rights to it and have opened it before.

Any suggestions would be greatly appreciated.....