Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Excel Shared Workbook not retaining format changes


(!)

JWoolley's Avatar
JWoolley JWoolley is offline
Junior Member with 4 posts.
THREAD STARTER
 
Join Date: Aug 2011
Experience: Intermediate
05-Aug-2011, 01:24 PM #1
Excel Shared Workbook not retaining format changes
I have an Excel Shared Workbook. I have multiple people editing by changing row color. The color formating is not always retained after saving and closing. It is being editied by people with office 2007. It is being saved in compatability mode (.xls) The file was originally given to me as a .csv.

I have seen several posts out there dating back to 2008 but no real answers. We have lost days worth of work.
Rockn's Avatar
Computer Specs
Member with 21,189 posts.
 
Join Date: Jul 2001
Location: Somalia of the North, MN
Experience: Disenfranchised American
05-Aug-2011, 02:15 PM #2
Is the file still a csv?
JWoolley's Avatar
JWoolley JWoolley is offline
Junior Member with 4 posts.
THREAD STARTER
 
Join Date: Aug 2011
Experience: Intermediate
05-Aug-2011, 03:15 PM #3
I saved it as a .xls
Rockn's Avatar
Computer Specs
Member with 21,189 posts.
 
Join Date: Jul 2001
Location: Somalia of the North, MN
Experience: Disenfranchised American
05-Aug-2011, 03:29 PM #4
Saving from a CSV to Excel format does not mean it will have any sort of normal formatting. I have run into this issue quite a few times with just the data and have had to edit the formatting for the proper data type. Not sure about the color issues
__________________
My no line signature
a
a
JWoolley's Avatar
JWoolley JWoolley is offline
Junior Member with 4 posts.
THREAD STARTER
 
Join Date: Aug 2011
Experience: Intermediate
05-Aug-2011, 03:36 PM #5
It is odd because some of the changes stay and others don't. If you highlight 10 rows, save and close, then when opened 4-6 random rows will no longer be highlighted.
Rockn's Avatar
Computer Specs
Member with 21,189 posts.
 
Join Date: Jul 2001
Location: Somalia of the North, MN
Experience: Disenfranchised American
05-Aug-2011, 04:02 PM #6
I would go through the columns and see what format each are in. I have had CSVs with what were supposed to be numbers having an extra space in front of them not formating as numbers, remove the space and they would format correctly.
JWoolley's Avatar
JWoolley JWoolley is offline
Junior Member with 4 posts.
THREAD STARTER
 
Join Date: Aug 2011
Experience: Intermediate
12-Aug-2011, 11:02 AM #7
There are 11 clumns and 19,000 row. The columns are either a number or text. The number columns seem to all be formated correctly. No leading spaces or zeros. The The only thing we are doing is changing the fill color.

Someone had configured sorting column headers. I unshared and removed those and reshared last Friday. Thought it might have fixed it but the color formating change disappeared again today.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
excel, format, issue, problem, shared workbook

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑

Content Relevant URLs by vBSEO 3.3.2