• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. P

    Excel file optimization

    Dan, I couldn't do that because it's an empty template, but .... Your idea got me thinking on how to find the cause of the size explosion. As I did with the example I copied the sheets one-by-one to a new workbook and saved them separately to get a view on the size per sheet. This learned me...
  2. P

    Excel file optimization

    Thanks for reviewing Dan. The Description field is only used for a brief description of the issue, it is however possible that in the comments/resolution field a lot of text will entered. This is however far from always the case. Like said, the workbook exists of six similar sheets and is as...
  3. P

    Excel file optimization

    Thanks already for your feedback. The file is a so called RAID log (which stands for (R(isks), A(ctions), I(ssues), D(ecisions), etc), this workbook exists of multiple sheets with the same structure (comparable with Chandoo's Issue Tracker). Per sheet there are columns with validation...
  4. P

    Data Validation - Entry limited to x.00 or X.50 decimals

    Great stuff Luke, exact what I was looking for !
  5. P

    Hello .. Introduce yourself

    Hi I'm Phill, working as project manager in Belgium. I use Excel a lot for reporting and tracking of projects but I also support my colleagues as " Excel Guru" although I'm no that experienced if I read the solutions here at Chandoo. There is still a lot to learn from other people experiences...
  6. P

    Excel file optimization

    Hi (again), I was wondering if there is a way to optimize an Excel file so that it becomes smaller in size. I have created a logging sheet which includes a lot of repeating formulas and conditional formatting which is as template nearly 10Mb in size. With the things I learn here at...
  7. P

    Data Validation - Entry limited to x.00 or X.50 decimals

    Hi, I'm working on a timesheet in which users must enter their time in decimals (e.g. 7.50) rather than in hours and minutes (e.g.7:30). To prevent that users enter invalid data, I'm looking for a way to limit the input to fixed decimals (e.g. 7.50 or 6.00 is correct, 7.30 or 6.45 is invalid)...
Back
Top