successfully saving inserted worksheets?

[Guest]

Hi. I have 15 spreadsheets saved. I have to add 14 of them to the 1st one as inserted worksheets. I was previously assisted in this by being advised the following, “ Open the destination workbook (what you call the
first one) and at least one of the other workbooks. I say at least one because you may not have the memory to open them all. If you can open them all, then do so. With a source file open and the source sheet on the screen, Do Edit -Move Or Copy Sheet. In the "To book:" box, select your destination file. Check the "Create a Copy" box. In the "Before sheet:" box select where in the sheet sequence of the destination file you want to put this sheet. Click OK. Done. Repeat this process for each of other 13 files.â€
I was able to do this successfully (Thanks Otto!) , but unfortunately, when I attempt to save it, I get the following message:

"The selected file type does not support workbooks that contain multiple sheets.
-to save only the active sheet, click ok.
-to save all sheets, save them individually using a different file name for each, or choose a file type that supports multiple sheets
OK CANCEL
********if click ok then…***********
MYNAMEquizzes.scv.cvs may contain features that are not compatible with CSV (Comma delimited). Do you want to keep the workbook in this format?
-to keep this format, which leaves out any incompatible features, click yes
-to preserve the features, click no. Then save a copy in the latest Excel format.
-to see what might be lost, click help
help yes no"

If I click yes, It will only save the main quiz & the other 14 do not appear. If I click no, then I don't know how to save in "the latest Excel format". I'm using excel 2002 (10.2614.2625). Any ideas?

 

[Kevin Stecyk]

Michelle,

Go
1) File Save As,
2) Save as type: *.xls

You are attempting to save a CSV (comma separated values). Save as an XLS
(XL spreadsheet) and you should be fine.

Hope that helps.

Regards,
Kevin

Hi. I have 15 spreadsheets saved. I have to add 14 of them to the 1st one

as inserted worksheets. I was previously assisted in this by being advised
the following, " Open the destination workbook (what you call the

first one) and at least one of the other workbooks. I say at least one

because you may not have the memory to open them all. If you can open them
all, then do so. With a source file open and the source sheet on the
screen, Do Edit -Move Or Copy Sheet. In the "To book:" box, select your
destination file. Check the "Create a Copy" box. In the "Before sheet:"
box select where in the sheet sequence of the destination file you want to
put this sheet. Click OK. Done. Repeat this process for each of other 13
files."

I was able to do this successfully (Thanks Otto!) , but unfortunately,

when I attempt to save it, I get the following message:

"The selected file type does not support workbooks that contain multiple sheets.
-to save only the active sheet, click ok.
-to save all sheets, save them individually using a different file name

for each, or choose a file type that supports multiple sheets

OK CANCEL
********if click ok then.***********
MYNAMEquizzes.scv.cvs may contain features that are not compatible with

CSV (Comma delimited). Do you want to keep the workbook in this format?

-to keep this format, which leaves out any incompatible features, click yes
-to preserve the features, click no. Then save a copy in the latest Excel format.
-to see what might be lost, click help
help yes no"

If I click yes, It will only save the main quiz & the other 14 do not

appear. If I click no, then I don't know how to save in "the latest Excel
format". I'm using excel 2002 (10.2614.2625). Any ideas?