Solved

Excel/Access 2007/2010 vba chart error "specified dimension is not valid"

Posted on 2013-06-17
5
1,336 Views
Last Modified: 2013-06-22
I have a procedure in Access 2010 that creates a spreadsheet and adds some data and charts. This works correctly in Access 2010, but when I run it in Access 2007 with Excel 2007, upon saving I get the error "the specified dimension is not valid for the current chart type." I have tried saving in different Excel formats, but all return the same error.

Does anybody have any idea why a procedure that works as intended with Access 2010 would be returning this error when run in Access 2007?
0
Comment
Question by:dgmoore1
  • 2
  • 2
5 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 167 total points
ID: 39253397
it could be a compatibility issue...
upload a copy of the A2007 version.
0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 333 total points
ID: 39253857
It is probably a backward compatibility issue.

You really should develop and test in the lowest version of Office you want to support. You will need to make sure that your code will run with 2007. I find that id I write code that will work in  2007 that is will also work fine in  2010. But not the other way around.

NOTE: Excel 2010 has new features exposed in he object model (available in VBA)  that are not available in 2007.

also see:

http://www.rondebruin.nl/win/s5/win002.htm

Working with the Compatibility Checker in Excel 2007 and Excel 2010
http://msdn.microsoft.com/en-us/library/office/gg132972%28v=office.14%29.aspx
http://office.microsoft.com/en-us/excel-help/worksheet-compatibility-issues-HA010343040.aspx
0
 

Author Comment

by:dgmoore1
ID: 39254314
I agree that I should be developing in the version my users have, but our CIO insists that developers lead the way (as guinea pigs) with upgraded applications, so we have to use versions that are ahead of our users, unfortunately.
0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 333 total points
ID: 39268193
WOW. Unfortunately the makes it very difficult to support Office/VBA applications in prior versions.

Sounds like you will have to do a lot of testing to see what features are backwardly compatible.

Hope you are paid by the hour.
0
 

Author Comment

by:dgmoore1
ID: 39268321
The company is rolling out Office 2010 as assets are replaced. When a box goes back on lease return its replacement has Win 7 and Office 2010 installed. We're talking thousands of workstations at numerous locations, so it's going to take a while to get everybody on the same page. The vast majority of users only need a browser, Word and maybe Excel to do their jobs, but there are scattered requirements for other tools and custom applications.

Fortunately, if there is an ad hoc requirement for Office 2010 we can get it installed, which is what I did this week to solve my current problem. I seem to be the lucky guy who runs into obscure issues because I'm usually building stuff that nobody else does, so we don't have much of a knowledge base.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now