Hi,
I have a problem with a workbook that contains several sheets with formulas and pivot tables for generating information based on a 'raw data' sheet.
whenever I refresh the raw data sheet from an external file, all the formulas are shifted to look at cells to the right of the cells they should be looking at.
Is there something I am missing
Sounds almost like your raw data is being imported 1 column to the left of where your range is looking?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The raw data always starts at A1.
The formula seems to shift 4 cells over whenever I refresh the data?!
This applies to multiple formulas on several sheets in the workbook.
The only common denominator is that all the formulas are looking at entire columns.
eg F:F becomes K:K for example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks