Hi All,
Relatively new to Jet but this problem is doing my nut in.
I have a report set up that pulls TB's from various companies into a spreadsheet and other tabs that pull information from these TB's. I've used this TB report successfully for a number of different spreadsheets but having imported them into a new worksheet all of a sudden something has gone wrong. Whenever I refresh them now the formulae all disappear which never happens in any of my other reports and so I get zero values for all my TB's. I'm at a loss to understand what has happened or what has changed.
Any suggestions welcome.
Paul
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment SOLVED - the formulae in cell A1 (Auto+Hide+etc) had copied over very oddly. Sorted now!!
-
Jet Reports Historic Posts Sorry I forgot to mention that when I set up the report and run it it works fine -it's only when I try to do a refresh that all of a sudden all the formulae have vanished and only the first line of data is present but is hard coded now, no formulae.
Please sign in to leave a comment.