?
Solved

Problem to the file

Posted on 2015-01-19
2
Medium Priority
?
78 Views
Last Modified: 2015-01-24
Hi,
How to identify the reason of the problem attached herewith?
t935.png
0
Comment
Question by:HuaMinChen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 11

Author Comment

by:HuaMinChen
ID: 40559065
Here are the codes
    Worksheets("Data").Select
    Range("B6").Select
    ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh

Open in new window


being used on the Excel file. How to ensure it would work fine, on Excel 2007 version?
0
 
LVL 17

Accepted Solution

by:
Nik earned 1500 total points
ID: 40559201
It should work with Excel 2007 and later, but not with Office 2003 and previous versions.
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Suggested Courses

762 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