Forum

ExcelNovice2020
@novusexcel
Estimable Member
Joined: Feb 8, 2020
Topics: 18 / Replies: 49
Topic
Forum
Replies: 6
Views: 320
Reply
RE: Tables or Named Ranges with no Query

I do have them in groups. It involves 20 - 23 separate weeks and each week has about 6-7 sets of different queries. I got to thinking this morning, ...

3 years ago
Forum
Reply
RE: Tables or Named Ranges with no Query

I have a lot of queries within the PQ editor (over 100). I was just looking to simplify a little bit. It is a nightmare at times working with all th...

3 years ago
Forum
Topic
Forum
Replies: 6
Views: 218
Reply
RE: Expression.Error; Cannot convert the value null to type Logical.0:

At first, I had the code different with some "null catches" and thought I had fixed what you were referencing above. Apparently not. I am really i...

3 years ago
Forum
Reply
RE: Expression.Error; Cannot convert the value null to type Logical.0:

Before moving on, I thought I would see if there is anything else I can add to this to help me with my Expression.Error issues. It is difficult to pi...

3 years ago
Forum
Reply
RE: Expression.Error; Cannot convert the value null to type Logical.0:

I know. Agree with your assessment; I just cannot find it. And, it's not constant but upon auto refresh, I get the error, along with an occasional d...

3 years ago
Forum
Reply
RE: Cell Alignment Not Kept After Refresh

I tend to agree about the table format itself. I still think this can be done. Just missing something. I do appreciate the continued insight.

3 years ago
Forum
Reply
RE: Cell Alignment Not Kept After Refresh

Not sure. It just seems odd I've never had alignment issues prior (they were always preserved) but here it maintains the proper alignment in the odd ...

3 years ago
Forum
Reply
RE: Cell Alignment Not Kept After Refresh

All other formatting within the table is preserved with each update/data add. It is just the horizontal cell alignment of the even rows reverts back t...

3 years ago
Forum
Reply
RE: Cell Alignment Not Kept After Refresh

That is what is odd. I am fairly certain PQ does preserve the alignment, assuming the option is selected. It preserves the alignment if the rows wit...

3 years ago
Forum
Topic
Forum
Replies: 8
Views: 1001
Reply
RE: Subtract Distinct Rows

Thank you for pointing that out the PQ rounding default. To be certain, with this particular situation, wouldn't RoundingMode.Up accomplish the sa...

3 years ago
Forum
Reply
RE: Subtract Distinct Rows

Just a quick note here, incorporating RoundingMode.Up with the Number.Round seems to solve my rounding issue.

3 years ago
Forum
Page 2 / 5