Free Microsoft Excel 2013 Quick Reference

Open Excel file get error with file names that have spaces in the

I started with a problem that all my excel files would open in the same excel
run. I did a few things to fix that through control panel/folder
options/advanced/open. I think that got fixed but then each file I opened had
a series of errors. Each space in any path or file name gave a message that
the file wasn't found. Then sometimes the file would eventually open,
sometimes not. Seems that once it got opened once, I could reopen it but if I
halted Excel and started over, the same happened.

I went back and reversed all the changes I made in folder options.

This seems to be happening immediately after installing a MS update and
restarting.

Frustrating. thanks for any help.
Kozmo


Post your answer or comment

comments powered by Disqus
If I open a spreadsheet from an FTP site, and the spreadsheet has a space in
the name, then Excel will always open the file as read-only. If I rename the
file to exclude the space in the name, then Excel will open it and allow me
to save any changes to the file. Any ideas what's happening? How can I open
a file named "My Spreadsheet.xls" directly from an FTP site? Is this a known
bug or a feature?

Here are a few of the details: I'm using Excel 2002 (10.6501.6714) SP3 and
the FTP site is using authenticated login, not anonymous. It's an IIS FTP
server on Windows 2000.

Thanks,
Dave

I have calculations using mround in my spreadsheet and am getting errors all
of a sudden. This is the second time that it has happened to me. I have
opened the spreadsheet alot since I fixed the errors the first time and as I
opened it yesterday, I received an popup that said that "File error: data may
have been lost" and when it opens, the #n/a is displayed where the mround
calc was. Any ideas?

None of my excel files (Outlook 2003) can be opened. Message: please wait
while Windows configuresoutlook standard 2003. Then further message:
Installation error file not found, run original CD. Have tried but the CD
will not run

For some reason the pivot table I've built, after refreshing, continues to show names of salespersons in the drop filter box for salespersons that are no longer in the data. They used to be, but are no longer - yet their name still shows up in the filter box...

No amount of refreshing the data itself or the pivot table seems to make those 'ghosts' want to go away - any ideas? Thanks!!

Hey Everyone,

I'm trying to open excel files with VBA and copy data into a master file. But, the file locations will be changing for these files, so I'm trying to use a named range in order to always provide VBA with the updated, correct file path. The named range would refer to a cell in the worksheet that contains the updated file path. So far the named ranges don't seem to be pulling any of the information that is contained within the cells.

Is this even possible? I'm pretty new to this. Here's my code:

Sub CutAndPaste()

Dim MasterFileName As String

Dim DataFileLocation1 As String
Dim DataFileName1 As String
   
    Workbooks.Open Filename:=DataFileLocation1
    Cells.Select
    Selection.Copy
    Windows.Activate Filename:=MasterFileName
    Sheets("Sheet1").Select
    Range("A1").Select
    ActiveSheet.Paste
    Windows.Activate Filename:=DataFileName1
    ActiveWindow.Close
Just FYI: MasterFileName, DataFileLocation1 and DataFileName1 are the named ranges.

I would basically repeat this two more times with two other files. The error I get is that the named range basically contains nothing when I try to run it, so Excel can't find the file.

Also, does it make sense the way I am reactivating the data file based on it's name from another named range to close it?

I really appreciate any help or advice!

Thanks!!
Ben

This may be very elementary (apologies in advance if that's the case), and my fear is that the Excel version of this file is gone for good, but here goes in hopes someone has a solution...

We have a workbook with multiple worksheets saved on a shared drive, with worksheets 2 through 11 in the workbook linked to cells in worksheet 1 in the same workbook. Not that it's necessarily relevant, but edits are only made in worksheet 1. One of my employees tried to open the file earlier today, said something looked strange about it, so he closed it, then reopened it, made some changes, then saved and closed it again.

When anyone (including him) now tries to open the file, they receive the infamous "file format is not valid" error message. Although he says he doesn't recall the specifics, my suspicion is that he was in MS Word and mistakenly tried to open the file there, saw the "Open Worksheet" popup, selected "Entire Workbook," saw that it looked a bit different than the regular version (his "something strange" reference), closed it, then reopened it in Word, disregarded the strange appearance, made his edits, and saved it, even after Word would've prompted him that it was going to save it in Word format.

I've been able to recreate the scenario exactly as detailed above using a test file, and although the file still displays as being Excel format in Explorer, and still has the .xls extension, trying to open the test file from either Explorer or directly within Excel gives me the same error we're getting with the one he played with.

I can open the test file (and the bad one) in Word, and although I get the data, it's in tables stacked one on top of the other, and with much of the formatting skewed. It isn't pretty, and doesn't give us the original template on which to build or adapt it going forward. (I know---this is why we create backups, but getting our MIS folks to restore from backups isn't an easy process.)

I guess I could take the tables one by one and copy them back into Excel, but that's a messy proposition due to size, formatting, etc., and I'm hoping there's an easier alternative. Does anyone know ANY way to revert the file to Excel format so that it can be opened there, ideally getting us back to the version before things went wrong? For reference, we're using both Word and Excel 2000.

Thanks in advance for any help you can offer.

John

I’m getting an intermittent Excel 2007 “changes could not be saved” error under Win 7 that did not occur under Vista.

I’m working in a macro-enabled file that I use every day. It has about 15 tabs. Sometimes when I save the file, I get the following message requiring me to follow the sequence shown here:

1. “Your changes could not be saved to ‘filenam.xlsm’ because of a sharing violation. Try saving to a different file.” Only one Excel file is open and I respond with okay which is my only choice.

2. Then I get the message “The file your are trying to open, ‘65E6A400’, is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?” I respond with no.

3. Then I get the message “Your changes could not be saved to ‘filename.xlsm’, but were saved to a temporary document named ‘65E6A400’. Close the existing document, then open the temporary document and save it under a new name” I respond with okay which is my only choice.

4. Then I close the file and close Excel

5. Then I re-open filename.xlsm (the original file) and it sometimes appears to have all of the recent changes but sometimes it doesn’t. Sometimes the original file does not have all of the changes and I have to delete the original file and open the file ‘65E6A400’ and re-save it with the original filename.

I’ve been using this file for several years and I never had a problem under Vista (Excel 2007) or XP (Excel 2003). Can you please help me resolve this problem?

Thanks,

Don Krafft

I want excel to open without Book 1. Following the thread below solves only
part the problem.

This works for opening only excel, but does not appear to work when one
double clicks on an existing excel file to open. I still get the Book 1 when
this is done. The /automation modifier does not seem to help either.

Our IT people put in a shortcut in the C:Program FilesMicrosoft
OfficeOFFICE11 directory with the /e /automation switch. The Control
Panel/Folder Options/File Types was modified to open excel using this
shortcut. Now, unless Excel is already open, a double click of an existing
file gives a series of files not found errors. It seems to stumble over the
spaces in the file structure such as between the word DOCUMENTS and the word
AND when looking for a file in C:Documents and SettingsExcel........ It
says it cannot find the file Documents.xls.

The /e used to work in older versions either with excel only or by double
clicking on a exisitng file. Either way, no Book 1 ever appeared. I am
after this same functionality.

ksn

"Dave Peterson" wrote:

> Modify the shortcut (or create an new shortcut) that points at excel.exe, but
> add " /e" (w/o the quotes) to the end of the target.
>
> For me (xl2003), my target would look like:
>
> "C:Program FilesMicrosoft OfficeOFFICE11EXCEL.EXE" /e
>
>
>
> Jwhite wrote:
> >
> > How do I set Excel to not load/create a "New" Book1, Book2, etc... whenever I
> > open Excel?
>
> --
>
> Dave Peterson
>

--
ksn

hi all

I have three of many excel spread sheet files that I use and update daily
that I can no longer access not even copy, move or Attached so I can send
them via email . I tried to access these files and I get the
following message: "Cannot access read only document "file-name"". I am on
Excel 2000 and Windows 2000 pro. I have checked out the properties on all
files. None of them have the "read only" box ticked and there is only the
General
Tab. Also, there is no longer an author for these three files. All the rest
that can be accessed have an author, normal attribute, and have General,
Custom, Summary tabs. I do not recall doing anything different. I ran a
virus scan on the files with no viruses indicated. Can anybody help me? I
tried my last backup file but the backup file have the same problems.
Please help

I have suddenly begun experiencing a problem when trying to open Excel files
or the application itself. I get Windows Installer saying it's trying to
load Office XP Small Business, and asking for the CD. I don't have the CD,
as my PC came loaded with Office already on it. When I subsequently click
"Cancel", I get an "Error 1706... setup cannot find the required files".

I have not done anything new to my PC, and suddenly this problem. What gives?

Any help would be appreciated.

Thanks in advance,
AMC

I have suddenly begun experiencing a problem when trying to open Excel files
or the application itself. I get Windows Installer saying it's trying to
load Office XP Small Business, and asking for the CD. I don't have the CD,
as my PC came loaded with Office already on it. When I subsequently click
"Cancel", I get an "Error 1706... setup cannot find the required files".

I have not done anything new to my PC, and suddenly this problem. What gives?

Any help would be appreciated.

Thanks in advance,
AMC

hi all

I have three of many excel spread sheet files that I use and update daily
that I can no longer access not even copy, move or Attached so I can send
them via email . I tried to access these files and I get the
following message: "Cannot access read only document "file-name"". I am on
Excel 2000 and Windows 2000 pro. I have checked out the properties on all
files. None of them have the "read only" box ticked and there is only the
General
Tab. Also, there is no longer an author for these three files. All the rest
that can be accessed have an author, normal attribute, and have General,
Custom, Summary tabs. I do not recall doing anything different. I ran a
virus scan on the files with no viruses indicated. Can anybody help me? I
tried my last backup file but the backup file have the same problems.
Please help

This is a new problem and is driving me crazy! I am installing Office 97 (word, excel only) on a windows 2003 server. I have outlook xp installed as well. Office 97 has been updated to service release 2b. Basically when you try and open an excel file three error messages will display before it opens the file. The messages are: "C:documents.xls can not be found" "C:and.xls" cannot be found" & "C:Settings.xls" cannot be found.

It seems that it has to do with the spaces in the path, but can't really change that. Here's the kicker though, I have 13 other servers that are all exactly the same and they are not acting this way. However I installed Office 97 on them about 6 months ago, since then I have built 4 servers which are displying this error. I have searched high and low and can't figure out any logical explination for this or a fix. Does anyone have any suggestions at all?

Thank-you very much!!!

Hello excel Guru's

I have a hyperlink that changes value based on the criteria in other cells.

I would like a macro that opens the hyperlink that is located in cell F3

I on occation the value of the hyperlink is greater then 255 so on those occations I want to open the file name that is compiled in H3

and then do the same for F4 and H4.

I already have a macro for saving these files with specific names so that I can harvest the data into a master sheet I just cant work out how to open a workbook when the name is stated in a cell.

I am on XL 2003

Help!

Please

edit:

Thought would ad the code I have tried so you can see what I am on about

Range("F3").Select
Workbooks.Open Filename:=F3
ActiveWindow.Visible = False
Application.Run "SaveCompare2"

about 6 months ago Excel closed from errors generated when the copy tab to
another workbook command was used. upon reboot, could no longer open Excel
files from desktop; had to be inside Excel to open file. If attempting to
open from desktop would get error message: "cannot find the file 'C/Documents
and Settings/Administrator/Desktop/Work/Excel Workpapers/filename.XLS (or one
of its components). Make sure the path and filename are correct and that all
required libraries are available". Tried reinstalling the Registry, didn't
work. Tried Excel problem solver, didn't help. Tried reinstalling Small
Business, did'nt help. Am using Excel 5.0 under Windows Professional 2000 on
an IBM laptop. How do I fix this?

This line works...

Set working = Workbooks.Open("L:theFolderTheEmail.xls")

this one returns a 1004 error...

Set working = Workbooks.Open("L:theFolderTheEmail.xls")

getting "smart" I tried...

Set working = Workbooks.Open("""L:theFolderThe Email.xls""")

The file in question WILL have a space in the name when we receive it. Is
there some trick to opening the file when there's a space in the name?

Maury

I have a Windows 2000 machine w/ Office 2000, for some reason it will not
open Excel files anymore. When I open and Excel files the "Excel.exe has
created an error" box appears, then I get another box that says "Can't find
the file (or one of its components) that I am trying to open. If I run Excel
in /safe mode or /automation mode it works fine.

Help, anyone.

Hi, I'm trying to check to see if a sheet named "Test Matrix" exists in any
open excel file. I would also like my macro to copy this worksheet if it
isn't in the current workbook that the macro was run from. This is the code
I found in the newsgroups so far which is a start. Thanks in advance!

Public Function WSExist(wsname As String) As Boolean
'returns true if worksheet exists in the active workbook
Dim objWorksheet As Object
On Error Resume Next
WSExist = False
Set objWorksheet = ActiveWorkbook.Sheets(wsname)
If Err = 0 Then WSExist = True
End Function

Sub TestMatrix_Chk()

If WSExist("Test Matrix") = False Then
MsgBox ("No Test Matrix sheet found!")
End If

End Sub

I'm helping someone recover an excel file. When I try to open the file I get
the following error. Is there anyway to recover this file? THANKS!

Problems During Load

Problems came up in the following areas during load:
PivotTable

In the XMLErrLog.txt file

XML Spreadsheet Warning in PivotTable
REASON: Missing Tag
ACTION: Aborting current XML group
FILE: C:Documents and SettingsAdministratorDesktopSummary 090705.xls
GROUP: PivotItem
TAG: Name

XML Spreadsheet Warning in PivotTable
REASON: Missing Tag
ACTION: Aborting current XML group
FILE: C:Documents and SettingsAdministratorDesktopSummary 090705.xls
GROUP: PivotItem
TAG: Name

XML Spreadsheet Warning in PivotTable
REASON: Missing Tag
ACTION: Aborting current XML group
FILE: C:Documents and SettingsAdministratorDesktopSummary 090705.xls
GROUP: PivotItem
TAG: Name

XML Spreadsheet Warning in PivotTable
REASON: Missing Tag
ACTION: Aborting current XML group
FILE: C:Documents and SettingsAdministratorDesktopSummary 090705.xls
GROUP: PivotItem
TAG: Name

XML ERROR in PivotTable
REASON: Missing Tag
FILE: C:Documents and SettingsAdministratorDesktopSummary 090705.xls
GROUP: ElementType
TAG: attribute

Hi Anyone who can give me a hand?

I am trying to open excel files in a file path which includes folders which also have excel folders i wish to open there are quite a few.

At the moment i am working with this code but it fails to open excel files which are within the folders in the specified file path. Its fine for excel workbooks in the folder specified by file path.

This is the code i am using can anyone help?

Sub RunCodeOnAllXLSFiles()
Dim lCount As Long
Dim wbResults As Workbook
Dim wbCodeBook As Workbook

Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False

On Error Resume Next

Set wbCodeBook = ThisWorkbook

With Application.FileSearch
.NewSearch
'Change path to suit
.LookIn = "L:filesmystuff"
.FileType = msoFileTypeExcelWorkbooks
'.Filename = "Book*.xls"

If .Execute > 0 Then 'Workbooks in folder
For lCount = 1 To .FoundFiles.Count 'Loop through all.
'Open Workbook x and Set a Workbook variable to it
Set wbResults = Workbooks.Open(Filename:=.FoundFiles(lCount), UpdateLinks:=0)

'DO YOUR CODE HERE

wbResults.Open SaveChanges:=True

Next lCount
End If
End With

On Error GoTo 0
Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.EnableEvents = True
End Sub

Hello,

I want to switch between open excel files. How can I do this without having to use the specific file name?

Same question with switching between tabs without having specific tab names?

Thanks much,
Brian

EXCEL:Can't open any file without error saying it's ALREADY open???

It's a gigantic alert box when you opened an existing XLS file telling
you the file is ALREADY open and asks for ok, cancel etc.

OFFICE 1997 is the version.

I am opening excel files from access using application.followhyperlink.
The excel file always opens with the workbook restored down.
Is there any way to open the file with the workbook maximized using
application.followhyperlink from access?
One annoying thing is that after using application.followhyperlink from
access, after I have closed both access and excel, the next time I open excel
from the desktop, it opens with the workbook restored down.

Thanks

Hello,
I am trying to create a macro that will perform the following in order:
1) Open Reuters, outside website (not even sure if you can perform this from
a macro)
2) Open an Excel File to update with the Rueters information by hitting the
"Update" popup after opening the file.
3) Close the Excel File
--
Regards,

Tsp245


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