Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Excel

Sep 21, 2015 6:45AM PDT

I have a calendar file that contains references (I'm guessing) to cells that update the year/month, etc. Once I have it the way I want to use it, I would then like to tell it to save as strictly a text file. In other words, I don't want any references, macros, etc. to save with the file, can I do that? If so, how? Currently if I save the file, then enter an appointment it enters the same appointment in each month - I don't want that. Help!

Discussion is locked

- Collapse -
Answer
Excel
Sep 21, 2015 6:48AM PDT

Sorry, I forgot to mention that I am using Excel 2010 and Excel 2013 (home and work).

- Collapse -
Answer
Re: Excel
Sep 21, 2015 7:03AM PDT

Not very clear.
- Cells don't update anything, so your first line is totally unclear.
- What do you mean with references?
- If you enter one appointment and it multiplies that appointment it's programmed to do so. If you don't like that, change it.

If you save it as pdf, strictly seen it isn't a text file and you can't very well read in in Notepad, but it might be useful for you anyway.

Kees

- Collapse -
Answer
You could always use Print Screen.
Sep 21, 2015 7:09AM PDT

You could get what you want on the screen, then hit ALT-PrintScreen, then paste it into Paint, then crop out the part you want & paste the result into a word processor like Word. That would save it as a graphic. That's about all I could tell you without actually seeing the spreadsheet.
`
Good luck.