Buffistas

Sir? I think you have a problem with your brain being missing.

Zoe ,'The Train Job'

Buffistechnology 3: "Press Some Buttons, See What Happens."

Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!

First Previous Next Last Recent

Jessica - Sep 15, 2015 4:48:26 pm PDT #24605 of 25496

And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

My Excel wizardry has reached its limit. I have a very complicated spreadsheet with lots of cross-referenced data, and a set of data model-built pivot tables which are pulling in data from three separate tables.

Today I built a new table to cross-reference the source data in a different way, and now suddenly my pivot tables aren't working. The error message I'm getting comes up twice and says:

"The query did not run or the data model could not be accessed. The string '8/25/2015' cannot be converted into the date type."

I've Googled this error message and absolutely nothing helpful is coming up. What I want to know is how I can find this problematic string so that I can fix whatever it is. This spreadsheet is FULL of dates, and that one appears many times over multiple columns across several tabs - I've looked for as many versions of it as I can and none of them seem to be doing anything differently than they were this morning!

Jessica - Sep 15, 2015 4:55:33 pm PDT #24606 of 25496

And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

Update:

I've deleted the new table and the error message is still there. So it's not that. ARGH.

Jessica - Sep 15, 2015 4:59:28 pm PDT #24607 of 25496

And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

Stranger and stranger...

I replaced every instance of '8/25/2015' with '8/24/2015' and it's still giving me the IDENTICAL error message, even though this spreadsheet no longer contains any cells with '8/25/2015' in them.

Sophia Brooks - Sep 16, 2015 2:54:40 am PDT #24608 of 25496

Cats to become a rabbit should gather immediately now here

Omins- if you are here, I am wondering if you know anything about assigning tasks in Wunderlist. I made the list and shared with my students, but the only person I can see to assign tasks to is me!

Otherwise it seems to be working, but I have to email the student to tell them what I want them to do

Sophia Brooks - Sep 16, 2015 2:54:41 am PDT #24609 of 25496

Cats to become a rabbit should gather immediately now here

Nevermind- I figured it out!

omnis_audis - Sep 16, 2015 6:30:53 am PDT #24610 of 25496

omnis, pursue. That's an order from a shy woman who can use M-16. - Shir

Woot for figuring it out.

Jessica - Sep 16, 2015 7:01:32 am PDT #24611 of 25496

And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

For anyone still following my Excel ordeal, I wound up simply pulling the last offline version where the pivot tables still worked, and replacing the data with values from the live version, and then saving the now-updated working version back to Sharepoint. I feel like this:

[link]

-t - Sep 16, 2015 7:12:34 am PDT #24612 of 25496

I am a woman of various inclinations and only some of the time are they to burn everything down in frustration

I kind of want you to send me the wackaloon 8/25/15 version so I can poke at it, but I really should not let that suck up my life like I know it would...

Jessica - Sep 16, 2015 7:18:34 am PDT #24613 of 25496

And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

If it weren't all confidential data, I totally would!

SuziQ - Sep 16, 2015 9:04:20 am PDT #24614 of 25496

Back tattoos of the mother is that you are absolutely right - Ame

I feel your pain, Jessica. Glad you found a work around. And HELL YES on the xkcd.

First Previous Next Last Recent