Buffistas

Funny thing about black and white. You mix it together and you get gray. And it doesn't matter how much white you try and put back in, you're never gonna get anything but gray.

Lilah ,'Destiny'

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

Discussion Threads

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 25501

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 25501

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 25501

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 25501

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 25501

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 25501

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 25501

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 25501

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 25501

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 25501

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