General discussion

Locked

Excel Copied Sheet - File not Found

By SusanGehrig ·
I copy a sheet from an existing workbook into a new workbook to upload it onto a website. When a user opens it, an open box called "File Not Found" is displayed to browse the computers files. I think it is because my spreadsheet has links to other cells on various sheets in the old workbook. What can I do to turn off the search for the file with the links?

Thank you.

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by BFilmFan In reply to Excel Copied Sheet - File ...

That is indeed the issue. You can either place the required files (the other worksheet references) up on the website or you could simply paste the value of those cells into the new worksheet.

Collapse -

by SusanGehrig In reply to

When I just paste the values with "paste special" the formatting is removed. If I "paste special" to include the formatting the hyperlinks still remain which are causing the problems.

Collapse -

by dryflies In reply to Excel Copied Sheet - File ...

In the original workbook, save the sheet as a file that does not support multiple worksheets. Load the new file, then save as an excel workbook. All of the links that cannot be resolved will be changed to values.

Collapse -

by SusanGehrig In reply to

What do you mean by save as a file that does not support multiple worksheets? Do you mean to save it with the extension for Excel Worksheet 4.0? I am not familiar with this.

Collapse -

by dryflies In reply to Excel Copied Sheet - File ...

That is exactly what I mean. when you get to the save as dialog, choose excel worksheet 4.0 in the save as file type pulldown. save the file. now close excel and reopen, saying no when it asks you to save changes to worksheet.xls. reopen the worksheet.xls file and all of the links to your other sheets in the old workbook will have been resolved to values. I just thought of something. Are you using save as web page? if you are, there is a directory called <your workbook name>_files in the directory where you saved your workbook. they must also be uploaded to the web site or you will get the dreaded 404. If you are not using that, you should try it. that may also get rid of your error.

Collapse -

by SusanGehrig In reply to

Poster rated this answer.

Collapse -

by awfernald In reply to Excel Copied Sheet - File ...

Once you have copied the sheet over, go to "Edit - Links", and delete all of the external reference files that you find listed there, or redirect them to the appropriate location.

Collapse -

by MalcolmH In reply to Excel Copied Sheet - File ...

You don't say what version of Excel you are using, but the later versions have a "Break Links" option. From the "Edit" menu, select "Links..." then clisk the "Break Link" button on righthandside

In earlier versions the "Copy, Paste Special, Values" does work.
Copy all your data to your new workbook, using normal copy/paste. then select all the data in the new book and do copy, paste special, values over the top of it.

Collapse -

by SusanGehrig In reply to Excel Copied Sheet - File ...

This question was closed by the author

Back to Software Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums