ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Spreadsheet Column Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/135438-spreadsheet-column-formatting.html)

Mike J.

Spreadsheet Column Formatting
 
HWhen sending a s/s via email I lose column formatting on the receiving end.
How do I prevent format lost by locking in the settings?

Wood Grafing

Spreadsheet Column Formatting
 
Send the spreadsheet as an attachment, not in the body of the e-mail. From
what I've seen, if you send it any other way than as an attachment, you stand
the chance of the formatting becoming corrupted or changed.

"Mike J." wrote:

HWhen sending a s/s via email I lose column formatting on the receiving end.
How do I prevent format lost by locking in the settings?


Mike J.[_2_]

Spreadsheet Column Formatting
 
Thanx for response... but I'm sending as an attachment. When the s/s is
opened the column formatting is lost. I'm going to try posting it to
SharePoint and sending a link. Hopefully the formatting will stay in tact
when you open from Sharepoint.

Thanx again,
mike J.


"Wood Grafing" wrote:

Send the spreadsheet as an attachment, not in the body of the e-mail. From
what I've seen, if you send it any other way than as an attachment, you stand
the chance of the formatting becoming corrupted or changed.

"Mike J." wrote:

HWhen sending a s/s via email I lose column formatting on the receiving end.
How do I prevent format lost by locking in the settings?



All times are GMT +1. The time now is 05:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com