Unformatted, formatted excel documents(?)

  • Thread starter Thread starter shnim1
  • Start date Start date
S

shnim1

Is this possible...

I have a formatted documnet that I distribute with variable column/ro
sizes, gridlines off, colors, boxes etc etc. Is it possible tha
someone else could open that document and and see the same document bu
in an UNFORMATTED view. I didnt think that this was possible, but wante
to see if anyone else has had this problem.

Thank
 
Is this possible...

I have a formatted documnet that I distribute with variable column/row
sizes, gridlines off, colors, boxes etc etc. Is it possible that
someone else could open that document and and see the same document but
in an UNFORMATTED view. I didnt think that this was possible, but wanted
to see if anyone else has had this problem.

Thanks
Click to expand...

I think because Excel formatting is embedded into the spreadsheet
itself so it doesn't matter who open it. They will see the same
spreadsheet as you do.
Hope this helps

Westie
 
By "someone else" do you mean anyone else but yourself or a specific "someone"?

It would be simple enought to wipe out the formatting by VBA code if the
"someone" was identified as the workbook opener.

Or you could wipe out the formatting in a copy you distributed to "someone"
before you send the copy.

Post back with details.


Gord Dibben MS Excel MVP
 
Thanks for the response..

I have a workbook that I am going to commercially distribute. All o
the Beta testers do not see a problem, apart from one person wh
downloaded the folder and loaded it on his machine (newish lapto
running xp). He says that the spreadsheet is unformatted, and we shoul
delay distribution.

I think he is stalling (for some reason) as I dont think it is possibl
that a formatted spreadsheet will be unformatted when opened.

Any thoughts?
 
If your workbook had code that produced the formatting upon opening the workbook
I could see the user not allowing macros, thus not allowing the formatting.

If the formatting was established prior to sending the workbook I could not
imagine formatting not being there.


Gord
 
Back
Top