Jump to content

Worksheet Problem in 2012 / 2013


M5d

Recommended Posts

I'm moving to 2012 and can't get my existing worksheets from 2011 and earlier versions to function in 2012 or 2013. For energy efficiency calculations I pull data from spaces and windows for ventilation figures but database worksheet cells no longer seem able to do calculations based on the column head figures.

There's a stripped down worksheet in the attached file, the problem is in cell F4, if anyone would be willing to take a look.

Link to comment

Hi Juan, thanks for taking a look.

The attached files are exactly the same in their respective versions.

The 2011 version shows how the worksheet used to function, subsequent versions don't respond to the column sum function as they have previously.

I don't know if this is an intended change or a bug resulting from the unlimited sum functions they added in 2012.

If it's an intended change, interpreting data on worksheet rows is no longer possible.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...