These two problems are related, or so it would seem. When I fixed the "File error: data may have been lost." problem by adding more formats, the mangled name of the first sheet problem also corrected itself.