Jump to content

Laura Stone

Member
  • Posts

    159
  • Joined

  • Last visited

Everything posted by Laura Stone

  1. Was there an answer to this? I'm having the same problem.
  2. Whenever I try to open a file across our network using the last location drop down menu at the top of the 'Open' dialogue window VW 2008 crashes. This doesn't happen for any other application. Is this a bug?
  3. Hugues, Thanks very much - that works. You have saved us a whole load of time! Laura
  4. We use a system of symbols with record formats to make co-ordinate tables for setting out. This worked fine in VW12, but we're having problems in VW2008 to do with references within the formulae. We use excel to make the list of numbers and then copy them in to the first column. As an aside it would be nice if the worksheets had an excel-like feature where you can add the first couple of numbers then select and drag to get the rest. We then have a formula in each of the next two columns that references the X-centre and Y-centre of the symbols with the record given in the first column. In VW12 we could do that using e.g. =XCENTER((('Co-ord'.'Ref'=A2))) but this doesn't seem to work any more for new worksheets (bizarrely old worksheets still update OK). See the enclosed drawing with three symbols with records, the first two rows contain the formula and a reference to the cell containing the record number - this has not worked. The last row has the record number entered manually and does work - however with some of our drawings having 600 co-ordinate references I'm not too keen to have to revise each record manually. Anyone have any ideas??
  5. Thanks Pat - that works perfectly. Laura
  6. As far as I can work out these two methods recalculate all of the worksheets, I only want to recalculate the one I have open, or even better only one cell. Is there any way of doing this?
  7. We have lots of worksheets on our drawings and generally only want to update one at a time as it otherwise can take up to an hour. Is there a way of doing this? Laura
×
×
  • Create New...