0

Auto+Hide changes after run report

Jet Reports Historic Posts

April 14, 2014 17:06

None

Follow

Hi. I'm having this issue pop up and advice is much appreciated!

Cell A1 = Auto+Hide
After I run the Jet Report, it has changed to:
A1 = Auto+Hide+Formulas = Sheet9, Sheet10

If I run the report again with the new value in cell A1, it is wrecking my report.

I'm running Office 2013 64-bit with Jet Essentials 2013 for 64-bit.

Any ideas on how to make it stop changing the value in A1?

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts April 16, 2014 13:17

  Hi,
  please copy your code to a new blanket excelsheet and try it again.
  If that is ok, then save the new excelsheet.
  I've have had this problem some times, too…
  
  btw: Do you save it after using excel-filters?
  
  regards
  jetsetter

• 0
  
  Jet Reports Historic Posts April 16, 2014 16:59

  No, I wasn't using any filters. After running the report several times, the value in A1 quit changing on me. If it happens again, I'll try copying and pasting it. Or I'll try to setup a macro that checks the values in A1 whenever the file is opened. Thanks for the tip!

• 0
  
  Jet Reports Historic Posts April 17, 2014 06:55

  Hi,what i was thinking about is, to copy your code, before running it again, to refresh your report on a new excel-sheet, so not copy after the error occurs…