Discussion Locked

Excel Copied Sheet - File not Found

0 helpful
9 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

9 replies

by bfilmfan

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.

by susangehrig

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.

by dryflies

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.

by susangehrig

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.

by dryflies

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 _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.

by awfernald

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.

by want-to-leave-tech-r

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.

This discussion is closed to new replies.