Form changes size
Posted by Michaela on April 21, 2000 11:26 AM
Well, I have a REALLY stupid thing that is happening with a form. It is set up and available to the network on the main server. When one person opens and closes the same file several times, it gets smaller and smaller each time.(also prints out smaller) His settings appear to be the same as everyone elses. Does anyone have any other suggestions I could try? We usually have to reboot his individual computer to get back to normal settings. If anyone else opens the same spreadsheet, it will be fine for them. Thanks for any help you can offer.
Posted by Keith Hoar on April 24, 2000 1:06 PM
I have run into similar problems. Differing screen sizes, a formula in cell C5 gives different results from the exact same formula in D5, cell attributes do not agree with displayed settings.
The above symptoms have been found whenever a Lotus file is converted to Excel or if an Excel file have been modified and modified and modified .....
The only way I hoave found to fix these problems is to recreate the spreadsheet from scratch.
This have been such a common problem, in fact, that as a company standard we create a template workbook, with only column width, row heights, range names, etc. Then after edit - test, cycle is complete, we copy and paste the formatting into the blank template and "save as" to a new name.
See John Walkenbach's book "Power Programming with VBA" for a description of Excel's internal pointer corruption that leads to this kind of problems.
HTH
Keith
Posted by Michaela on April 27, 2000 5:15 AM
Thanks so much! I will try to check in that direction. I appreciate the help and will start doing the template as you suggest for future forms.
