Unformatted, formatted excel documents(?)

[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

 

[westie144]

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

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

 

[Gord Dibben]

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

 

[shnim1]

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?

 

[Gord Dibben]

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