Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tim C
 
Posts: n/a
Default how do I keep a large workbook from losing all formatting upon cl.

I have a couple of very large workbooks (12k) with specific page breaks and
print ranges. Upon opening each time there are changes in print formats,
margins, and even formulas lost and replaced with Values. Each time I save I
also lose my hyperlinks to let users go directly to the cell they use to
start the day's business. This is in an attempt to make a workbook adding
monthly values in each sheet x 12 months, and a summary sheet. It is not
overly complex, but the re-formatting is making me look for other solutions.
I would prefer not to have to have a workbook for each month, and then use 12
separate workbooks, one for each month, times four departments, you get the
idea.
Any assistance would be appreciated! TC
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Are you saving the file as a .xls file (Microsoft excel workbook (*.xls))?

It kind of sounds like you're saving as a .CSV (comma separated values).

That kind of file (.csv) is plain text. Formats and formulas are not saved.

I'd do a file|SaveAs and check that bottom box.

Tim C wrote:

I have a couple of very large workbooks (12k) with specific page breaks and
print ranges. Upon opening each time there are changes in print formats,
margins, and even formulas lost and replaced with Values. Each time I save I
also lose my hyperlinks to let users go directly to the cell they use to
start the day's business. This is in an attempt to make a workbook adding
monthly values in each sheet x 12 months, and a summary sheet. It is not
overly complex, but the re-formatting is making me look for other solutions.
I would prefer not to have to have a workbook for each month, and then use 12
separate workbooks, one for each month, times four departments, you get the
idea.
Any assistance would be appreciated! TC


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Losing conditional formatting when saving Eric FD Excel Discussion (Misc queries) 3 January 19th 05 12:42 AM
pasting into an excel template without losing the formatting chachi Excel Discussion (Misc queries) 2 January 14th 05 05:08 AM
Lotus 123 save as excel workbook and maintain formatting? Don Excel Discussion (Misc queries) 0 December 8th 04 01:15 AM
make large worksheet from workbook Cowtoon Excel Discussion (Misc queries) 5 December 6th 04 09:24 PM
Cells losing formatting BdgBill Excel Discussion (Misc queries) 1 November 26th 04 09:03 AM


All times are GMT +1. The time now is 06:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"