0
Last night I have saved my work in a excel file and when I opened the file in morning, the formatting was lost. Columns in all the sheets are shrunk (see below image). I had accessed this workbook from citrix as it was on my office server and the last time I saved all was perfect. What can be the reason for this issue?
Santosh
Posted 2015-12-02T13:02:54.013
Reputation: 133
1it seems like you accidentally applied the column width (all narrow columns were selected and you dragged them to change width) – Máté Juhász – 2015-12-02T13:58:30.073
Not sure we will be able to tell you the cause of it. Were you able to fix it? – CharlieRB – 2015-12-02T14:44:15.373
Are any of those shrunk columns empty? Are all the ones that aren't empty the same size in pixels? What about the empty ones? – Raystafarian – 2015-12-02T14:46:29.753
@MátéJuhász It can't happen to all the sheets. – Santosh – 2015-12-02T14:47:10.830
@Raystafarian Columns to the right are empty and have shrunk and are of same size. I have added a image. – Santosh – 2015-12-02T14:50:41.153
1Most likely some commands in citrix got weird or there was a hiccup that selected all sheets, then all cells and then, as @MátéJuhász said, somehow a click and drag occurred to that width – Raystafarian – 2015-12-02T14:53:19.417
For the record, ctrl+shft+pgdn, if stuck, will select all sheets. – Raystafarian – 2015-12-02T14:55:25.753
@Raystafarian It can be the reason, but I feel there is remote possibility for it as I was careful and I am sure that I have saved it properly. – Santosh – 2015-12-02T14:55:58.340
Maybe someone else did it? Remember that when you connect through citrix, the viewing resolution is distorted, so who knows what it thinks server-side. edit check here for a different example.
– Raystafarian – 2015-12-02T14:59:16.573