I just ordered a laptop with a 256GB SSD, an i5 processor, and 8GB of RAM. Between Amazon gift cards and credit cards rewards point, the leftover total was $88.
I am excite.
Willow: It feels like we're going around in circles. Xander: Our circles are going around in circles. We got dizzy circles here.
'Sleeper'
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!
Dana - Sep 12, 2015 12:37:35 pm PDT #24604 of 25496
I'm terrifically busy with my ennui.
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:
-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!