Change Queries in a Worksheet Without Affecting References

Change Queries in a Worksheet Without Affecting References

Published: 01/March/2004

Reading time: 6 mins

The results for multiple queries are often placed in one Excel worksheet, which is then referenced to other sheets in the workbook. This practice, which is embraced by many, can cause problems, however, if a query changes the cell, column, or row structure in the sheet containing the results areas. The author demonstrates a easy...

This content is for Mastering SAP Premium Access and Mastering SAP Preferred Access members only.
Log In Join Now

More Resources