Hi guys,
Is there way to tell Jet to leave a particular sheet in a workbook alone? It seems that Jet processes every sheet in a workbook but for the work I'm doing, I need to maintain a specific format that needs the first column in Excel.
Thanks so much. I appreciate your help guys.
Date
Votes
3 comments
-
Jet Reports Historic Posts Jet Reports is going to add that "Auto+Hide" to all of your sheets, moving the first row and column out of the way to add that command to A1
There are some options, depending on your workbook and what you are trying to accomplish.
1. if you can schedule your report, there is a setting that will let you delete any hidden rows & columns after it is run. If this would work, you could set up your report with the extra row/column on each sheet - but then have the hidden data deleted in the scheduled formula.
2. can you add your worksheet that needs to be untouched AFTER the Jet Report has run?
3. can you maintain the worksheet that needs to be untouched as a separate file from the Jet workbook?
perhaps an example of what you have going on will help with other ideas. -
Jet Reports Historic Posts Thanks Heather.
Option 3 was my backup plan if there wasn't a simple Jet keyword. I wasn't aware of the delete blank lines function so I will have to explore that one for future use.
Cheers! -
Jet Reports Historic Posts Good luck Mcemanuel, and I would definitely recommend checking out the scheduler option - it has made my life MUCH easier for Jet Reports.
Please sign in to leave a comment.